Calc ne conserve pas la hauteur de ligne quand je supprime un contenu de cellule
Vous pouvez définir la hauteur des lignes via le menu : Format - Lignes - Hauteur.
Posts from every feed QUEST has found across the web — blogs, news, podcasts, channels and more.
Vous pouvez définir la hauteur des lignes via le menu : Format - Lignes - Hauteur.
Hi, Suppose that one has chosen Libreoffice Writer to create a book and it’s time to send it to the print house… But oops, they need bleed area and printer marks… I’m aware that writer can’t add a bleed area… see: How to add marks and bleed to a PDF export But what about printer marks? Is there a way to do that? thank you advance! Peter
Bonjour, Merci de votre réponse.Je souhaitais faire une présentaion sur Impress mais le texte que je souhaitais coller dans la zone de texte dédié sur la dia ne s’affiche pas complètement ( il sort de la zone de texte et n’est pas complètement visible. Ce matin, j’ai laissé tombé les textes pour intégrer les images et des vidéos. tout s’est bien passé jusqu’à un point de blocage complet ! impossible d’intégrer une vidéo et surtout impossible d’ouvrir la présentaion faite. Impossible de…
https://help.libreoffice.org/latest/ja/text/shared/01/profile_safe_mode.html
Bonjour, mon problème = lorsque je supprime un contenu de cellule (avec ou sans la fenêtre de confirmation), Calc modifie la hauteur de la ligne. Comment éviter cela ? (version LO 27.2.3.2, sur macOS Monterey 12.7.6)
Hello The Example from help for LAMBDA works for me with Version: 27.2.0.0.alpha0+ (AARCH64) Build ID: c0ade982f09c8fcc1d0b484cab0051c6db8b0110 CPU threads: 4; OS: Linux 6.18; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded compiled from master because there are no daily-builds for arm64
(post deleted by author)
Bonjour, comme indiqué :aller dans le menu LibreOffice > Apparence > Activer les thèmes d'application et cocher la case “Activer” (attention, je ne sais pas si vos préférences système de votre ordinateur modifient ou pas le fonctionnement de cette activation).
Sure, here it is. I meant to add it in the initial post but new accounts aren’t allowed to upload more than one file in a post. brown-text-exerpt.odt (27.3 KB)
Yes, exactly, the first thing I see is the sentence: “This is ar tst.” with the AR being in red. I am gonna try and remove fibre office completely and reinstalling it.
rp-chem: Any ideas would be appreciated. We might come up with some ideas if we could see an uploaded sample .odt file that reproduces the effect mentioned above.
Hi, maybe check the wiki, they are usually documented here, like: https://wiki.documentfoundation.org/Documentation/Calc_Functions/LAMBDA maybe not all of them are yet documented, but should be in the near future
Villeroy: Apart from the double-quote (typo?), labels in single quotes refer to entire rows and entire columns. Yes a type. And no, both are columns. The reference refers to the cell in that column and the same row as the cell mking the reference. I was not aware of the ability to refer to a row and a column.
EDIT: Sorry, I found the alignment setting in the Edit TOC dialog. I thought I’d understood that I shouldn’t do that there. But this worked. Sorry for the interruption. As you probably have guessed, I’ve just given up on roman numerals in the TOC. So I’ve got a TOC looking pretty good but I’ve changed my mind about the way the top level works. I had it centered with no page number. Now it’s flush left with a page number, but I can’t get the page # moved to the right with … leaders. So can…
A solução encontrada mostra como um detalhe nas aspas e na estrutura da fórmula pode causar o erro 511 no LibreOffice Calc. Ao usar SEERRO envolvendo toda a expressão, é possível deixar a célula vazia quando não houver valores para calcular a média. É sempre útil conferir também se as aspas usadas na fórmula são as aspas retas esperadas pelo Calc. Para quem procura ajuda com dificuldades para visualizar Stories do Instagram, o conteúdo Não Consigo Ver Story Instagram pode ser uma referência…
The latest version 26.8.2.2 on Kubuntu added labels to the tabbed toolbar view. These labels take up a LOT of vertical space. Is there any way to remove them?
Ich habe einmal versucht, das Problem nachzustellen: Seitenformat auf Querformat gesetzt Absatz mit Tabulator bei 10 cm, 20 cm und 25 cm gesetzt und Text sowie Tabulatoren genutzt Seitenformat auf Hochformat gesetzt Text mit Tabulator 20 cm rutscht in die nächste Zeile nach vorne, Text nach Tabulator 25 cm nimmt den 10 cm Tabulator Neuen Text geschrieben und Tabulatoren genutzt. Der Tabulator für 20 cm wird beim Schreiben rechts vom Blatt angezeigt, der Text aber dann in die nächste Zeile…
azalea4va: SlipData[[#This Row],[Last Name]]) This syntax exists for Excel compatibility only. It’s not stored in the native file format. azalea4va: $‘BaseCost’ + "Type1Cost’ Apart from the double-quote (typo?), labels in single quotes refer to entire rows and entire columns. If ‘BaseCost’ refers to a row and ‘Type1Cost’ refers to a column (or vice versa), 'BaseCost'!'TypeCost' gets the intersecting cell. azalea4va: = INDEX(TBL_MY, ROW(), MATCH(“Lot 1”, TBL_Hdr_MY, NOT_SORTED)) Calc and Excel…
Wird leider auf der Hilfe-Seite nicht erklärt!
I’d like it to be chapter number, like “Picture 1.1” would mean that it is first picture in chapter 1
Assuming your first number is chapter number and you added your caption with Insert → Caption, i.e. you insert first your picture, then select it and invoke the menu command: when the insert caption dialog pops up, press Options… button in the Heading Number Before Caption Number section, choose in Up to level the level of chapter numbering you want in the caption number 1 for chapter only, 2 for chapter+sub-chapter, etc. OK to return to the main caption dialog This procedure is valid for new…
ilykokoszki: I would like to number illustrations in my document as “Picture 1.1”, “Picture 1.2”, “Picture 2.1” and so on. How do you mean it? Do you want to do it based on Chapter number or Page number or what?
Hi there, It’s my first time using this site, so forgive me if I missed the same topic with the same question, but I have a problem. I would like to number illustrations in my document as “Picture 1.1”, “Picture 1.2”, “Picture 2.1” and so on. How do I do this? I can’t find an option to number my pictures like this and by default they are numbered as “Picture 1”, “Picture 2” and so on. How do I fix this? I’d be very grateful if somebody would help me

Hallo quick gothic headings-numbering by python: hundreds = [''] +list(map(chr, range(66370,66379))) tens = [''] + list(map(chr, range(66361,66370))) ones = [''] + list(map(chr, range(66352,66361))) guard = chr(8226) # '•' def to_goth_num(number): h, rest = divmod(number, 100) t, o = divmod(rest, 10) h, t, o = hundreds[h], tens[t], ones[o] return f'{h}{t}{o}' def goth_number_headings(*_): doc = XSCRIPTCONTEXT.getDocument() undo_manager = doc.UndoManager undo = "undo_goth_numbers"…
If building fractions and exponents is the slow part, I built Nitrax Equation Editor to let you put those together visually in your browser. You can export the result as SVG or PNG and add it to your document as an image.
Yes! LibreOffice Math supports Greek letters, even though they don’t appear in the standard Elements panel. The easiest way is to type % followed by the Greek letter’s name directly in the formula editor: %alpha → α %beta → β %gamma → γ %pi → π %GAMMA → Γ You can also go to Tools > Symbols and select Greek from the symbol set. I actually ran into similar frustrations when typing mathematical expressions frequently, which eventually led me to develop a specialized mathematical keyboard to make…
Put =PRODUCT(A:A) in B1 to multiply all the numbers in column A. Blank cells and text are skipped, and a zero makes the result zero.
If you can get the MathML for one of the formulas showing ???, copy it and try Tools → Import MathML from Clipboard in LibreOffice Math. If it still shows ???, could you share a small MathML example that does it?
Writer still follows the decimal numbering sequence when you change the font. Gothic uses one character for 90 (𐍁) and another for 900 (𐍊), so for a short fixed list I’d type the labels by hand