We will be migrating from Ask to Discourse on the first week of August, read the details here

 Poser votre question

# Profil de CyanCG - activité

2018-05-18 10:03:42 +0200 médaille reçue  Jolie réponse (source)
2018-04-23 16:25:10 +0200 médaille reçue  Bonné réponse (source)
2018-03-09 13:58:11 +0200 médaille reçue  Jolie question (source)
2016-09-28 21:18:11 +0200 médaille reçue  Question célèbre (source)
2016-09-18 23:14:32 +0200 médaille reçue  Jolie réponse (source)
2015-08-31 08:50:30 +0200 médaille reçue  Question remarquable (source)
2015-08-31 08:50:30 +0200 médaille reçue  Question populaire (source)
2015-03-13 18:48:26 +0200 a commenté une réponse Inserting Hyperlinks in a LibreOffice Writer Document

I wholeheartedly agree. Also, I have long been wondering whether the heading style names should be more descriptive. For example, they could adopt the LaTeX levels: (book), part, chapter, section, subsection, subsubsection. This corresponds to common usage. Of course, this de-emphasizes the parallel with HTML headings, which are numbered from 1 to 6, but then again even the HTML heading numbers are out of place! (It would be better if browsers implemented the HTML5 outline algorithm).

2014-11-10 03:09:53 +0200 question commentée Librewriter screen display text gets messed up after scrolling

Then it probably has something to do with LibreOffice’s text display being handled by Java? I knew Java handled user interaction, but I wasn’t sure to what extent it was responsible for display in the document view. I am aware of other applications (such as PyCharm) where changing the JRE can dramatically alter the appearance of text.

2014-11-10 03:04:31 +0200 question commentée error in content.xml (related to annotations?)

Does the string <="" p=""> really appear right after style:name="P1"? If so, that is surely the cause of the problem. The sequence that begins with <style:style is the start tag for an “automatic style” element. Inside an XML start tag, the sequence <="" p=""> cannot appear, as it does not make sense (it would be like a start tag inside another start tag, which is not well-formed XML and, worse yet, this “start tag” would not have a legal XML name).

2014-07-17 14:15:33 +0200 médaille reçue  Nécromancien (source)
2014-06-30 01:09:56 +0200 question commentée Why does Writer freeze after Searching and Replacing line endings with spaces?

Now, if you must have absolutely no paragraph breaks in your text, you might find it hard to obtain this effect in LibO, but in CSS (hence, in a Web browser) you can set an element’s display property to inline! ;-) Of course, that doesn’t help much if you must produce a printed document.

2014-06-30 01:06:51 +0200 question commentée Why does Writer freeze after Searching and Replacing line endings with spaces?

The thing about Undo looks like a bug indeed, but why replace all carriage returns with spaces? Is it because you want the document to be only one paragraph? LibreOffice Basic indeed has a hard limit to the number of characters that it can handle in a string: 65534, which is the highest number that can be represented with 16 bits. However, I don’t know if that limit applies to the paragraphs themselves. In any case, the character limit is internal to LibO, as the saved XML has no such limit.

2014-06-30 00:55:16 +0200 question commentée Portable Libreoffice and Libreoffice UNO SDK C++

Have you looked around the Wiki? Perhaps an article about UNO or the SDK would help you find out whether your dependencies are included in the Portable version or not.

2014-06-26 00:46:45 +0200 médaille reçue  Etudiant (source)
2014-06-25 19:11:30 +0200 a commenté une réponse Which of HTML, JPEG, PDF and XML is best for importing data into a Calc spreadsheet?

The fact that the application refuses to export to Excel’s format if Excel is not present is infuriating. I agree with @Lupp that this should be illegal and that the ideal solution would be to use another application, but if this is not possible, opening the HTML in a browser as suggested by @Rugslug is a good idea, as then you can visualise everything that the file is supposed to contain.

2014-06-23 17:38:22 +0200 a répondu à une question Which of HTML, JPEG, PDF and XML is best for importing data into a Calc spreadsheet?

The best option seems to be to import the MS Excel file into LibreOffice Calc. Is it the legacy .xls or the new .xlsx? In both cases, LibreOffice’s support has steadily improved in recent versions.

If, after trying that, you realize that something is wrong or some data is missing, try HTML, which could then be opened in Writer, converted into OpenDocument tables and placed in Calc sheets.

Generic XML is problematic, unless you happen to know how to use an XML transformation language (XSLT or XQuery).

PDF and JPEG are generally unsuited to data export, as they are visual as opposed to structural. PDF could eventually allow you to keep the exact formatting produced by the accounting software, but JPEG is the least suitable of all: raster images are not much use in data workflows.

2014-06-22 17:49:57 +0200 a répondu à une question On ne peut quasiment pas éditer les macros fournies ?

De fait, la documentation officielle du langage LibreOffice Basic est déconcertante à plusieurs égards, mais il existe un excellent livre en français intitulé Programmation OpenOffice.org et LibreOffice et publié chez Eyrolles. Ce livre m’a permis de dépasser les écueils initiaux et de prendre en main le langage et les API.

Pour ce qui est de modifier les macros existantes, c’est possible, du moins en copiant le texte des macros incluses dans la bibliothèque standard et en les mettant dans une bibliothèque personnelle. On peut ainsi s’en servir comme point de départ.

À long terme et dans un monde idéal, le mieux sera éventuellement d’utiliser Python pour toute programmation de la suite bureautique, mais la facilité d’utilisation de Python n’égale pas encore celle de Basic, simplement parce que Python n’est pas encore assez intégré à LibreOffice (pas d’EDI, nécessité de stocker les scripts séparément etc.). Toutes autres choses étant égales, Python est un langage de loin supérieur à LibreOffice Basic. Cependant, s’il y a la moindre chance que les macros doivent être partagées avec des utilisateurs d’OpenOffice, Basic est préférable puisque Python n’est pas systématiquement distribué avec OpenOffice.

2014-06-07 12:40:55 +0200 médaille reçue  Nécromancien (source)
2014-06-03 16:02:44 +0200 a répondu à une question Open Word Doc (from Mac) in Writer and every paragraph is now on a separate page?

There are a few key stylistic changes which might solve the paragraph display problem.

It always helps to display invisible characters: the menu item to toggle that is ViewNonprinting Characters. Then, do you see paragraph marks between the paragraphs, or do you see page break marks? If you see the latter, then it probably means that all paragraphs have a page break as part of their applied style.

Now, the question becomes: has styling been applied consistently? If formatting has been applied manually and by multiple people, then probably not. However, most paragraphs should have the same base style, either Default, Body text, Normal or something like that. In order to know which style is applied to a paragraph, first display the Styles and formatting window by toggling the menu item FormatStyles and Formatting. You can anchor this window to the side (I highly recommend doing so and developing a habit of using it for literally every formatting-related task). Now, when you put the text cursor in a paragraph, that paragraph’s style will be highlighted in the Styles and Formatting window. This allows you to know which style you need to change.

Right-click the appropriate style’s name, then click Modify…. In the dialog box, go to the Text flow tab. There, under the Breaks heading, if the Insert box is checked, you have found the culprit. Uncheck the box and all paragraphs with this base style should now display normally, with natural breaks occurring at the bottom of the pages’ display areas.

Keep in mind that paragraphs might have manual formatting applied on top of the base style. If that is the case, even unchecking the break box in the style will not remove breaks if breaks were applied manually (Microsoft Word does such ridiculous things all the time, so it would not be surprising). The radical solution is to select all such paragraphs and choose the menu item FormatClear Direct Formatting. This is a good cure. If any other manual formatting was applied, it will be lost as well, but in any case the formatting should always be applied by creating named styles in the Styles and Formatting window.

Hope this helps!

2014-05-29 17:45:04 +0200 a commenté une réponse Professional writer form design examples

The crux is: in theory, the OpenDocument format allows complete styling of form elements, with full generality: ODF’s styling facilities are closely modeled on those of XSL Formatting Objects and CSS. In practice, when using LibreOffice, the interface for styling leaves much to be desired and LibreOffice’s layout engine is far from perfect, so that getting the exact desired layout is often a pain… How will users fill in the forms? In LibreOffice, in a PDF viewer or in a browser?

2014-05-01 05:16:36 +0200 question commentée How do I apply character styles to index entries?

I mean to say that modifying the appearance of entries and headings is not done in the index menu. In the index menu, you can select which styles apply to which entries or headings. In order to modify the styles themselves, you must select them from the Format > Styles and Formatting menu.

2014-04-23 22:25:50 +0200 question commentée How do I apply character styles to index entries?

The elements of the index have distinct paragraph styles, which can be accessed via the Styles and Formatting window. Logically, it is advisable to edit the properties of the paragraph styles instead of applying character styles “above” the formatting that the paragraph already has by virtue of its paragraph style. Inter-paragraph spacing is controlled in the paragraph style, not the character style.

2014-04-16 16:02:53 +0200 a commenté une réponse Convert all occurences of a style to another style

This will work if the character formatting is applied at the paragraph level, but if it is applied as character styles then the built-in Find and Replace dialog will not do: the “Alternate Find and Replace” extension will be necessary.

2014-04-14 02:02:57 +0200 médaille reçue  Question célèbre (source)
2014-03-25 03:19:14 +0200 a commenté une réponse Opening Apple Pages '09 docs.

Indeed. What I find most deplorable is that, while free software communities like LibreOffice’s are trying to raise awareness about formats and standardization, the likes of Apple try to shield users from such considerations as much as possible, as though such things were harmful. The effect is that, after all those years of near-universal use of office suites, people still don’t distinguish between an application and the formats it consumes and produces.

2014-03-25 02:58:48 +0200 médaille reçue  Entousiaste
2014-03-24 23:35:12 +0200 médaille reçue  Jolie réponse (source)
2014-03-24 19:39:52 +0200 a commenté une réponse When will LibreOffice have a ribbon UI (as in MS Office 2007-2013)?

I agree, and in my opinion the Ribbon UI is ill-suited to document design and authoring. LibreOffice has always had two excellent UI components which offer a visualization of and an access to most elements and tasks of document production: the Navigator for document elements and structure, and the Stylist for design and layout. However, and this is where the uphill battle is fought, using them appropriately requires a different conceptual view on what document production truly is.

2014-03-24 19:27:47 +0200 a répondu à une question Opening Apple Pages '09 docs.

Unfortunately, LibreOffice does not (yet?) have an import filter for iWork Pages documents. Writing one could be an interesting challenge, but also a pain since the Pages format is ill-defined and has no official public documentation.

Extracting the PDF from the Zip archive is indeed a satisfactory solution. In the unlikely event that the Pages user has disabled the inclusion of the PDF in the .pages file bundle and if the original author cannot be relied on to provide another version, here is the more involved solution:

• Unzip the archive and, in the unzipped directory, locate the index.xml file, which contains the whole text of the document.
• Depending on your familiarity with XML, you might choose to transform the XML into something else (many ways to do so, but none are trivial) or simply open the XML file in a Web browser and copy the text nodes, export them to simple text, etc. If you know some CSS, you can even style the text elements by writing CSS rules in the browser’s developer tools and then use this laid out text as a starting point for further processing.
2014-03-24 19:21:14 +0200 a commenté une réponse Opening Apple Pages '09 docs.

I agree, and I point also to this article by a dedicated Apple blogger who, like me, used to rely extensively on Pages and is now reconsidering his options. He is quite pessimistic and considers that there is no viable alternative (he calls the whole word-processing-on-the-Mac situation an utter mess), but I believe that LibreOffice is bound to become the best alternative (we’re just a few minor versions away from the ideal!) ;-).

2014-03-24 17:41:32 +0200 a commenté une réponse Professional writer form design examples

Complex and ergonomic forms can be created using LibreOffice, however I reckon that there are far fewer examples of such documents due to the adoption rate of LibreOffice in governments and enterprise, which is still relatively low (in other words, it is a question of inertia and habit). Are you looking for more programmability or more styling options?

2014-02-20 16:18:43 +0200 a commenté une réponse Exhaustive solution for HTML export

I do not understand what those filters do exactly: I only see some generic properties in them and nothing about mappings of XML elements to HTML elements.

2014-02-20 16:13:07 +0200 a répondu à une question I would like to import my Jabref bibliography into Libreoffice. The plugin will not let me select the style file, is there a workaround?

I feel very concerned by your situation, because, lately, I have been exploring different ways to use BibTeX or BibLaTeX data in LibreOffice. I do not use JabRef and do not know what export options it has, but I know that the modern BibLaTeX engine, Biber, can export a .bib file to an experimental XML format. I am currently working on a converter from this BibLaTeXML to HTML or ODT.

In the meantime, if you know a bit about LaTeX, here is what you can do to obtain a bibliography that is usable in LibreOffice:

1. Get a TeX distribution, like TeX Live (or MacTeX if you are on a Mac, or MikTeX on Windows);
2. Make a minimal LaTeX document in which you include your .bib file and process it with XeLaTeX and Biber;
3. Export either:
• the text of the resulting PDF document using a tool such as pdftotext or Adobe Acrobat;
• your LaTeX bibliography document to HTML or ODT using TeX4ht (this is more involved, but could be awesome).

If you choose to export just the text from the PDF, import the text in LibreOffice and style it. If you choose the TeX4ht way, you get an ODT and you can further enhance it by

• marking the bibliography entries as cross-reference targets

This is indeed a tedious process, but unfortunately I have not yet found a more automated alternative. I hope to get time to make my conversion tool soon…

2014-02-20 15:53:44 +0200 question commentée How to embed base64 MIME content in documents?

This would be very neat indeed. Do you want to embed a PDF document made of multiple pages, or a single-page graphic in PDF format?

2013-12-24 18:23:06 +0200 a commenté une réponse is it possible to search for text of a specific color?

Could it be that the RTF format’s properties can’t be handled by the extension’s code? @Sunny you could try to save the document as an ODT before attempting the replacements. What formats does the e-reader accept? LibO allows you to save the modified ODT back to RTF after the modifications are made. We’d only need to know if LibO’s RTF plays well with your e-reader model.

2013-12-07 23:14:15 +0200 question commentée what version fo .net does LibreOffice run under?

This is strange, the xhtml converter is AFAIK a set of XSLT stylesheets interpreted by LibO’s internal XSLT processor. If any part of LibO interacts with a .Net library, I don’t see why this should be related to XSLT execution… Have you tried running other tasks from the command line? If another task returned the same error, then you could at least suppose that the problem is not specific to XSLT processing.

2013-11-28 23:30:06 +0200 médaille reçue  Question célèbre (source)
2013-11-28 23:30:06 +0200 médaille reçue  Question remarquable (source)
2013-11-28 23:30:06 +0200 médaille reçue  Question populaire (source)
2013-10-18 00:18:55 +0200 marquée comme meilleure réponse Font rendering problem in Writer on Mac OS X

I use many different fonts in my documents and accurate rendering is critical to my work. So far, I've been very happy with LibreOffice's layout scheme, but there are some issues which seem specific to the Mac platform.

The main problem is that, sometimes, when using different styles (e. g. roman and italics) in the same sentence, the glyphs are not accurately rendered and appear deformed. Sometimes, glyphs in the italics fonts will "lean" on the roman glyphs next to them and add some unusual white space, possibly hiding parts of the roman font glyph. This also happens with whitespace characters, specifically with non-breaking spaces.

I've heard that LibreOffice on the Mac used ATSUI instead of Core Text for text rendering: is this the source of the problem?

Finally, the strangest part (from my point of view, at least) is that the deformed glyphs still appear deformed in a PDF exported from the .odt file! This seems to show that the appearance of the PDF explicitly depends on the visible state of the document at the time of exporting. Could anyone explain this behavior? Is it meant to be that way or not?

2013-10-18 00:06:33 +0200 marquée comme meilleure réponse Exhaustive solution for HTML export

## The facts

LibreOffice has long had two separate sets of features pertaining to HTML:

• A traditional concept of different HTML implementations, as reflected by the HTML Compatibility options which allow one to export to “Mozilla Firefox”, “Microsoft Internet Explorer” or “LibreOffice Writer”. Up until recently, the menu had a “Netscape” entry instead of “Mozilla Firefox” and even had a “HTML 3.2” entry. OpenOffice 3.4.1 still has these two ancient options.

• A more modern approach of exporting to XHTML through the File > Export menu. This exports XHTML 1.1 with MathML. The code is clean, but it has inline CSS and does not export everything (footnotes are not present in the output, for example).

Even worse, this page from the OpenOffice website suggests that the XHTML export filter is actually based on the former Star Writer XML format and only works with ODT because it internally maps SWX to ODT.

## The question

How come a new export filter from ODT to XHTML was never fully developed, considering the importance of being able to publish to the Web?

Furthermore, this would mean that the HTML version of the ODF 1.2 standard relies on an export filter that was not even designed to handle ODF? This would be seriously inappropriate. I assume said export filter was indeed used to produce this document, based on information in the head of the page’s source code: there is the comment <!--This file was converted to xhtml by OpenOffice.org - see http://xml.openoffice.org/odf2xhtml for more info.-->. Following the link in this comment, one finds a page that is more up-to-date than the previously mentioned one. On that page one can read:

Now as a sample filter, it is an optional installation component of OpenOffice.org 3.x, installed together with the 'XSLT sample filter' package. Within the Office the filter can be used when choosing the XHTML export from File->Export...

Most fortunately, the article gives the impression that the XSLT filter was indeed updated for ODF. However, it is considered an optional sample.

Why does this situation persist? Why is there no all-encompassing solution to impeccably export ODF 1.2 to XHTML 1.1 with full control over the mapping of elements and attributes? Of course, there is the Writer2XHTML extension, but this seems to be stagnant at the moment and the problem is that this kind of ...

2013-10-01 20:04:17 +0200 marquée comme meilleure réponse [Meta] Could we have a Meta-AskLibO?

Lately I have noticed that many posts are not questions but announcements and general information or queries. I understand that this is the only way to do it right now, but eventually it would be nice to have a «meta» companion site, just like they have on Stack Exchange sites. As a contributor to TeX.SE, I very much appreciate the relevance of such meta-sites.

Perhaps we could also have a blog of our own, again just like those other sites! It would be a great place to post tutorials and musings. If we had a blog, I would gladly submit articles for it on a regular basis.

Our community deserves to grow and thrive. Stack Exchange sites such as TeX.SE have great content and communities; I feel that we should get inspiration from them and attempt to gain even more visibility in the coming months.