The SVG export in Impress now supports a per-paragraph setting to handle semi-transparent shape text, while previously this was only possible to control at a per-shape level.

This work is primarily for Collabora Online, but the feature is available in desktop Impress as well.

Motivation¶

As described in a previous post, Impress already had the capability to have semi-transparent shape text, but the SVG export of this for the case when not all paragraphs have the same setting was broken.

Transparency in SVG can be described as a property of a group (<g style="opacity: 0.5">...</g>) and it can be also a property of the text (<tspan fill-opacity="0.5">...</tspan>).

The SVG export works with the metafile of the shape, so when looking for meta actions, it tries to guess if the transparency will be for text: if so, it needs to use the tspan markup, otherwise going with the g markup is OK.

What happened here is that meta action for a normal text started, so the SVG export assumed the text is not semi-transparent, but later the second line was still transparent, so we started a group element, and this resulted in a not even well-formed XML output.

Results so far¶

The relevant part of the test document is simple: just 3 paragraphs, the second one is semi-transparent (and also has a bullet, as an extra):

Once this was exported to SVG, this resulted in a non-well-formed XML, so you got this error in a web browser:

Once tweaking the transparency mask writer to check if text started already, we get the correct SVG render:

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

The bugfix commit was SVG export: fix handling of semi-transparent text inside a list.

The tracking bug was tdf#162782.

Want to start using this?¶

You can get a development edition of Collabora Online 24.04 and try it out yourself right now: try the development edition. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (25.2).

Writer now has support for doing partial layout passes when LOK clients have pending events, which sometimes improves interactivity a lot.

This work is primarily for Collabora Online, but the feature is useful for any LOK clients.

Motivation¶

I recently worked with a document that has relatively simple structure, but it has 300 pages, and most of the content is part of a numbered list. Pasting a simple string (like an URL) into the end of a paragraph resulted in a short, but annoying hang. It turns out we updated Writer's layout for all the 300 pages before the content was repainted on the single visible page. In theory, you could reorder events, so you first calculate the first page, you paint the first page, then you calculate the remaining 299 pages. Is this possible in practice? Let's try!

Results so far¶

The relevant part of the test document is simple: just an empty numbered paragraph, so we can paste somewhere:

This is a good sample, because pasting into a numbered list requires invalidating all list items in that list, since possibly the paste operation created a new list item, and then the number portion has to be updated for all items in the rest of the list. So if you paste into a numbered list, you need to re-calculate the entire document if all the document is just a numbered list.

The first problem was that Writer tracks its visible area, but LOK needs two kinds of visible areas. The first kind decides if invalidations are interesting for part of the document area. LOK wants to get all invalidations, so in case we cache some document content in the client that is near the visible area, we need to know when to throw away that cache. On the other hand, we want to still track the actually visible viewport of the client, so we can prioritize visible vs hidden parts of the document. Writer in LOK mode thought that all parts of the document are a priority, but this could improved by taking the client's viewport into account.

The second problem was that even if Writer had two layout passes (first is synchronous, for the visible area; second is async, for the rest of the document), both passes were performed before allowing a LOK client to request tiles for the issued invalidations.

This is now solved by a new registerAnyInputCallback() API, which allows the LOK client to signal if it has pending events (e.g. unprocessed callbacks, tiles to be painted) or it's OK for Writer layout to finish its idle job first.

The end result for pasting a URL into this 300 pages document, when measuring end-to-end (from sending the paste command to getting the first updated tile) is a decrease in response time, from 963 ms to 14 ms.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• cool#9735 sw lok: take LOK vis area into account when deciding idle layout
• Related: cool#9735 vcl lok: add an AnyInput() callback
• Related: cool#9735 sw lok: handle the AnyInput() callback during idle layout
• sfx2: fix crash in SfxObjectShell::IsHelpDocument()

The tracking issue for this problem was cool#9735.

Want to start using this?¶

You can get a development edition of Collabora Online 24.04 and try it out yourself right now: try the development edition. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (25.2).

Writer now has improved support for font fallback when you open a DOCX file that refers to fonts which are not available currently.

This work is primarily for Collabora Online, but the feature is fully available in desktop Writer as well.

Motivation¶

Font embedding is meant to solve the problems around missing fonts, but you can also find documents with stub embedded fonts that are to be ignored and our code didn't have any sanity check on such fonts, leading to unexpected glyph-level fallbacks. Additionally, once font-level fallback happened, we didn't take the font style (e.g. sans vs serif) into account, which is expected to work when finding a good replacement for the missing font.

Results so far¶

Here is how to the original rendering looked like:

Once the handler for the embedded fonts in ODT/DOCX was improved to ignore stub fonts where even basic glyphs were not available, the result was a bit more consistent, but still bad. Here is a different document to show the problem:

Note how now we used the same font, but the glyphs are always sans, not serif. So the final step was to import the font type from DOCX and consider that while deciding font fallback:

With this, we ignore stub embedded fonts from DOCX, we import the font type and in general font fallback on Linux takes the font type into account while deciding font fallback.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• tdf#162002 DOCX import: ignore subsetted embedded fonts for editing
• tdf#162002 DOCX import, font embed: only discard subset fonts with few glyphs
• tdf#162072 vcl, fontconfig: consider font-family-generic for substitute
• Related: tdf#162072 DOCX import: handle font family for characters
• tdf#162280 vcl: consider font family type for glyph caching

Want to start using this?¶

You can get a development edition of Collabora Online 24.04 and try it out yourself right now: try the development edition. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (24.8).

Writer now has improved support for toplevel line shapes when you import those from DOCX.

This work is primarily for Collabora Online, but the feature is fully available in desktop Writer as well.

Motivation¶

As described in a post from 2014, Writer reads the drawingML markup for shapes in DOCX files, including line shapes. While investigating a simple-looking problem around a horizontal vs vertical line, it turns out that there is a deeper issue here, and it looks like now have proper fix for this bug.

Results so far¶

Imagine that your company template has a nice footer in two columns, and the content in the columns are separated by a vertical line shape, but when you open your DOCX in Writer, it crosses the text of that footer instead:

While researching how line shapes are represented in our document model and how ODT import works, it turned out that the proper way to create a line shape is to only consider size / scaling when it comes to the individual points of the line, everything else (e.g. position / translation) should go to the transform matrix of the shape, then the render result will be as expected:

It was also interesting to see that this also improved other, existing test documents, e.g. core.git sw/qa/extras/ooxmlimport/data/line-rotation.docx looked like this before:

And the same fix makes it perfect:

Just stick to the rule: scaling goes to the points -- translation, rotation and horizontal shear goes to the shape.

For now, this is only there for toplevel Writer lines, but in-groupshape and Calc/Impress lines could also follow this technique if there is a practical need.

The "after" screenshots show ~no red, which means there is ~no reference output, where the Writer output would be missing.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

The bugfix commit was tdf#161779 DOCX import, drawingML: fix handling of translation for lines.

The tracking bug was tdf#161779.

Want to start using this?¶

You can get a development edition of Collabora Online 24.04 and try it out yourself right now: try the development edition. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (24.8).

Writer now has much better support for continuous / inline endnotes (not on a separate page) in Writer, enabled by default for DOCX files.

This work is primarily for Collabora Online, but the feature is fully available in desktop Writer as well.

Motivation¶

As described in a previous post, Writer already had minimal support for not rendering endnotes on a separate endnote page, but it was not mature enough to enable is by default for DOCX files.

Results so far¶

What changed from the previous "continuous endnotes" approach is that instead of trying to map endnotes to footnotes, we now create a special endnotes section, which only exists at a layout level (no section node is backing this one), and this hosts all endnotes at the end of the document. It turns out this is a much more scalable technique, for example a stress-test with 72 endnotes over several pages is now handled just fine.

Here are some screenshots:

As you can see, there were various differences for this document, but the most problematic one was that the entire endnote was missing from the (originally) last page, as it was rendered on a separate page.

Now it's not only on the correct page, but also its position is correct: the endnote is after the body text, while the footnote is at the bottom of the page, as expected. The second screenshot shows ~no red, which means there is ~no reference output, where the Writer output would be missing.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• tdf#160984 sw continuous endnotes: introduce an endnote section
• tdf#160984 sw continuous endnotes: add a way to find the endnote section start
• tdf#160984 sw continuous endnotes: fix testContinuousEndnotesMoveBackwards
• tdf#160984 sw continuous endnotes: fix CppunitTest_sw_layoutwriter3
• tdf#160984 sw continuous endnotes: switch to a section-based layout
• tdf#161083 sw continuous endnotes: fix layout with a section at doc end
• tdf#160984 sw continuous endnotes, DOC import: enable this unconditionally
• tdf#160984 sw continuous endnotes: enable DOCX import
• tdf#160984 sw continuous endnotes: fix the endnote container's top margin
• tdf#160984 sw continuous endnotes: fix the endnote separator position
• tdf#160984 sw continuous endnotes: fix the endnote separator length
• tdf#160984 sw continuous endnotes: fix crash on loading forum-mso-en-7731.docx
• tdf#160984 sw continuous endnotes: DOCX: import <w:endnotePr> pos == sectEnd
• tdf#160984 sw continuous endnotes: DOCX: export of <w:endnotePr> pos == sectEnd
• tdf#160984 sw continuous endnotes: fix the endnote continuation separator len
• tdf#160984 sw continuous endnotes: hide not functional UI in this mode

The tracking bug was tdf#160984.

Want to start using this?¶

You can get a development edition of Collabora Online 24.04 and try it out yourself right now: try the development edition. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (24.8).

Collabora Online now uses the Clipboard API if it's available in the used browser, getting rid of many annoying dialogs.

Motivation¶

The paste side was covered by an earlier post, but in short, if you're on Chrome (or Safari), you won't see the "can't paste" dialog:

Also you won't see a "Can't paste special" dialog:

Wouldn't it be nice to improve the copy side in a similar way?

Results so far¶

The primary reason why we needed similar, annoying dialogs for copy in the past is that the clipboard API was synchronous but the network API is async. This means that writing to the clipboard ("copy") is only possible with data that we have in the browser when the copy is executed. This is a problem, since in general we don't have data for your selection in the browser.

With the Clipboard API, the copy side can be improved as well. Instead of always fetching the HTML for a simple selection (even if you don't copy) and having a three step copy for complex selections, async clipboard write is now possible. This gets us rid of the "You need to download" dialog:

Also it eliminates the "Download completed dialog:

Instead, we still need to nominally write to the clipboard in the special keyboard or click context initiating the copy (Chrome doesn't require this, Safari does), but the written object can be a callback that will do the network operation for us.

Unfortunately it's hard to screenshot the new code, since part of the result is that all these dialogs are now eliminated, copy & paste just works. :-)

Note that this can be used also in Firefox, but first you need to set dom.events.asyncClipboard.clipboardItem to true in about:config.

The last part was to adapt tests to this new world, because previously it was handy to just create a selection and assert what would be copied to the clipboard as HTML, but now we don't download the HTML anymore every time you create a selection.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• Related: cool#8648 clipboard: extract parseClipboard() from Control.DownloadProgress.js
• Related: cool#8648 clipboard: use JSON when requesting HTML only
• cool#8648 clipboard: try to use navigator.clipboard.write()
• cool#8648 clipboard: fix desktop/writer/copy_paste_spec.js
• cool#8648 clipboard: fix desktop/calc/clipboard_spec.js
• cool#8648 clipboard: fix desktop/writer/undo_redo_spec.js
• cool#8648 clipboard: fix desktop/writer/track_changes_spec.js
• cool#8648 clipboard: fix most of desktop/writer/top_toolbar_spec.js
• cool#8648 clipboard: fix insert hyperlink dialog
• cool#8648 clipboard: fix desktop/writer/table_operation_spec.js
• cool#8648 clipboard: fix desktop/writer/searchbar_spec.js
• cool#8648 clipboard: fix desktop/writer/notebookbar_spec.js
• cool#8648 clipboard: fix desktop/writer/editable_area_spec.js
• cool#8648 clipboard: fix desktop/impress/undo_redo_spec.js
• cool#8648 clipboard: fix desktop/impress/delete_objects_spec.js
• cool#8648 clipboard: fix desktop/calc/undo_redo_spec.js
• cool#8648 clipboard: fix desktop/calc/top_toolbar_spec.js
• cool#8648 clipboard: fix desktop/calc/searchbar_spec.js
• cool#8648 clipboard: fix desktop/calc/searchbar_spec.js
• cool#8648 clipboard: fix desktop/calc/focus_spec.js
• cool#8648 clipboard: fix desktop/calc/delete_objects_spec.js
• cool#8648 clipboard: fix desktop/calc/autofilter_spec.js
• cool#8648 clipboard: fix desktop/calc/cell_appearance_spec.js
• cool#8648 clipboard: fix mobile/calc/apply_font_spec.js
• cool#8648 clipboard: fix mobile/calc/autofilter_spec.js
• cool#8648 clipboard: fix mobile/calc/bottom_toolbar_spec.js
• cool#8648 clipboard: fix mobile/calc/cell_appearance_spec.js
• cool#8648 clipboard: fix mobile/calc/delete_objects_spec.js
• cool#8648 clipboard: fix mobile/calc/insertion_wizard_spec.js
• cool#8648 clipboard: fix mobile/calc/searchbar_spec.js
• cool#8648 clipboard: fix mobile/calc/spellchecking_spec.js
• cool#8648 clipboard: fix mobile/impress/delete_objects_spec.js
• cool#8648 clipboard: fix mobile/impress/impress_focus_spec.js
• cool#8648 clipboard: fix mobile/impress/insertion_wizard_spec.js
• cool#8648 clipboard: fix mobile/impress/spellchecking_spec.js
• cool#8648 clipboard: fix mobile/writer/apply_font_spec.js
• cool#8648 clipboard: fix mobile/writer/delete_objects_spec.js
• cool#8648 clipboard: fix mobile/writer/insert_formatting_mark_spec.js
• cool#8648 clipboard: fix mobile/impress/insertion_wizard_spec.js
• cool#8648 clipboard: fix mobile/writer/track_changes_spec.js
• cool#8648 clipboard: fix mobile/writer/table_properties_spec.js
• cool#8648 clipboard: stop fetching the clipboard on text selection create in tests
• cool#8648 clipboard: fix idle tests

The tracking issue was cool#8648.

Want to start using this?¶

You can get a development edition of Collabora Online 24.04 and try it out yourself right now: try the development edition.

Calc now supports much better copy&paste when you transfer data between Google Sheets and Calc.

This work is primarily for Collabora Online, but the feature is fully available in desktop Calc as well.

Motivation¶

First, Collabora Online was using the deprecated document.execCommand() API to paste text, which is problematic, as the "paste" button on the toolbar can't behave the same way as pressing Ctrl-V on the keyboard.

Second, it turns out Google Sheets came up with some additional HTML attributes to represent spreadsheet data in HTML in a much better way, and Calc HTML import/export had no support for this, while this is all fixable.

Results so far¶

In short, Collabora Online now uses the Clipboard API to read from the system clipboard -- this has to be supported by the integration, and Calc's HTML filter now support the subset of the Google Sheets markup I figured out so far. This subset is also documented.

Note that the default behavior is that the new Clipboard API is available in Chrome/Safari, but not in Firefox.

For the longer version, here are some screenshots:

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• tdf#159483 sc HTML import: handle data-sheets-value attribute for the text case
• tdf#159483 sc HTML paste: handle data-sheets-value here, too
• tdf#159483 sc HTML import: handle data-sheets-value attribute for the bool case
• tdf#159483 sc HTML import: handle data-sheets-value attribute for the num case
• tdf#159483 sc HTML paste: handle data-sheets-formula attribute
• tdf#159483 sc HTML paste: handle data-sheets- attributes on a span
• tdf#159483 sc HTML export: handle data-sheets-value attribute for the text case
• tdf#159483 sc HTML copy: handle data-sheets-value attribute for the bool case
• tdf#159483 sc HTML copy: handle data-sheets-value attribute for the num case
• tdf#159483 sc HTML copy: handle data-sheets-formula attribute

The tracking issue on the Online side was cool#8023.

Want to start using this?¶

You can get a snapshot / demo of Collabora Office 24.04 and try it out yourself right now: try the unstable snapshot. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (24.8).

Writer now supports legal numbering for two more formats: DOC and RTF (ODT and DOCX were working already.)

This work is primarily for Collabora Online, done as a HackWeek project, but the feature is fully available in desktop Writer as well.

Motivation¶

Legal numbering is a way to influence the number format of values inherited in a multi-level numbering. Say, the outer numbering uses Roman numerals and the inner numbering uses X.Y as the number format, but the inner level wants to display the outer values as Arabic numerals. If this is wanted (and guessing from the name, sometimes lawyers do want this), then the inner number portion will expand to values like "2.01" instead of "II.01", while the outer number portions will remain values like "II".

Mike did 80% of the work, what you can see here is just the RTF/DOC filters.

Picking a smaller feature task like this looked like a good idea, since I wanted to spend some of the time on regression fixing around last year's multi-page floating table project.

Results so far¶

For (binary) DOC, the relevant detail is the fLegal bit in the LVLF structure. Here is the result:

It shows how the outer "II" gets turned into "2", while it remained "II" in the past. This works for both loading and saving.

The same feature is now handled in the RTF filter as well. There the relevant detail is the \levellegal control word, which has an odd 1 default value (the default is usually 0). Here is the result:

It shows that the RTF filter is up to speed with the DOC one by now.

As for the multi-page floating tables, I looked at tdf#158986 and tdf#158801.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• Related: tdf#158986 sw floattable: fix unexpected page break with sections
• tdf#158986 sw floattable: fix RTF import of table followed by \sect
• Related: tdf#150408 DOC filter: handle legal numbering
• Related: tdf#150408 RTF filter: handle legal numbering
• Related: tdf#158986 sw floattable, RTF import: use more setNeedPar()
• tdf#158801 sw floattable: fix crash with headers and interactive editing

Want to start using this?¶

You can get a snapshot / demo of Collabora Office 24.04 and try it out yourself right now: try the unstable snapshot. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (24.8).

This post describes some challenges around having multiple views of one opened document in LibreOffice core, when those views belong to LOK views, representing different users, with their own language, locale and other view settings.

This work is primarily for Collabora Online, but is useful for all clients of the LOK API.

Motivation¶

LOK views are meant to represent separate users, so we need to make sure that when a user sets their preferences and trigger an action, then the response to that action goes to the correct view, with the correct view settings.

This is different from the desktop LibreOffice use-case, where multiple windows are still meant to share the same user name, language, undo stack and so on.

Results so far¶

In this post, I would like to present 4 small improvements that recently happened to the LOK API to provide this wanted separation of views.

The first was an issue where two users were editing the same document, one busily typing and the other clicked on a link in Calc. What could happen sometimes is the link popup appeared for the user who typed, not for the user who clicked on the link:

This specific problem can be fixed by making sure that link click callbacks are invoked synchronously (while the clicking view is still active) and not later, when the current view may or may not be the correct one.

It turns out the same problem (async command dispatch) affects not only hyperlinks, but many other cases as well, where we want to stay async, for example, when one dialog would invoke another dialog, like the Calc conditional format -> add dialog:

There you don't want to change async commands into sync commands, because that may mean spinning the main loop inside a dialog, resulting in nested main loops. This can be fixed by making sure that async commands to be dispatched (sfx2 hints in general) are processed in a way that the current view at dispatch & processing is the same, which is now the case.

The third problem was around wrong language & locale in the status bar:

This is not simply a problem of missing translation, the trouble was that the status bar update is also async and by the time the update happened, the locale of the view on the left was used, for a string that appears on the right.

The way to fix this is to perform the update of toolbars/statusbar/etc (in general: SfxBindings) in a way that the language at job schedule time and at UI string creation time is the same.

The last problem was quite similar, still about bad language on the UI, but this time on the sidebar:

This is similar to the statusbar case, but the sidebar has its own executor for its async jobs, so that needed a fix similar to what the statusbar already had, now done.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• cool#7853 sc lok: fix bad view id on hyperlink click
• cool#7865 sfx2 lok: fix bad view id on async command dispatch
• cool#7492 sfx2 lok: fix bad view id / statusbar string on async binding update
• cool#7492 sfx2 lok: just set language/locale on async binding update
• cool#7492 sfx2 lok: set language/locale on async sidebar update

Want to start using this?¶

You can get the latest Collabora Online Development Edition 23.05 and try it out yourself right now: try the development edition. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (24.8).

This post is part of a series to describe how Writer now gets a feature to handle tables that are both floating and span over multiple pages.

This work is primarily for Collabora Online, but is useful on the desktop as well. See the 10th post for the previous part.

Motivation¶

Previous posts described the hardest part of multi-page floating tables: making sure that text can wrap around them and they can split across pages. In this part, we'll look at a case where that content is not just text, but the wrapping content itself is also a table.

Results so far¶

Regarding testing of the floating table feature in general, the core.git repository has 92 files now which are focusing on correct handling of floating tables (filenames matching floattable-|floating-table-). This doesn't count cases where the document model is built using C++ code in the memory and then we assert the result of some operation.

Here are some screenshots from the improvements this month:

The first screenshot shows a situation where the mouse cursor is near the right edge of the first page of a floating table. What used to happen is we found this position close to the invisible anchor of the floating table on that page, then corrected this position to be at the real anchor on the last page. In short, the user clicked on one page and we jumped to the last page. This is now fixed, we notice that part of the floating table is close to the click position and we correct the cursor to be at the closest position inside the table's content.

The next screenshot shows a floating table where the content wrapping around the table happens to be an inline table. You can see how such wrapping didn't happen in the past, and the new rendering is close to the reference now.

How is this implemented?¶

If you would like to know a bit more about how this works, continue reading... :-)

As usual, the high-level problem was addressed by a series of small changes:

• sw floattable: fix finding the nearest text in split flys on mouse click
• tdf#60558 sw floattable: allow wrap of table on the right of a floattable
• sw floattable: fix split of anchor text in 2nd half of the paragraph
• sw floattable: fix split of anchor text at para start
• sw floattable: fix outdated text frame portions after split
• sw floattable: disable UI to enable this when anchored inside TextBox
• tdf#158686 sw floattable: fix print preview crash

Want to start using this?¶

You can get a snapshot / demo of Collabora Office 23.05 and try it out yourself right now: try the unstable snapshot. Collabora intends to continue supporting and contributing to LibreOffice, the code is merged so we expect all of this work will be available in TDF's next release too (24.8).