[Libreoffice-bugs] [Bug 144521] New: FILESAVE: Stop storing empty cells

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144521

            Bug ID: 144521
           Summary: FILESAVE: Stop storing empty cells
           Product: LibreOffice
           Version: 7.2.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at prino.org

This is not a bug, and it's very well hidden by the fact that ODS files are
effectively ZIP files.

When working with a test file, I inserted columns/rows, deleted columns/rows,
changed the format of entire columns/rows, and eventually decided to have a
look at "content.xml" and where the XML writer does some (pretty minimal)
optimisations, for storing repeated cells, but it misses out on plenty cases,
where the resulting "content.xml" contains code like:

<table:table-cell table:number-columns-repeated="11"/>
<table:table-cell table:number-columns-repeated="45"/>
<table:table-cell table:number-columns-repeated="724"/>
</table:table-row>

In other words, a row that ends with 780 empty columns, that are still "stored"
in the file, and need to be parsed when reading it in. Same happens for rows,
with is an order of magnitude worse, as there can be a million of them.

It would/might be nice if the XML writing code could stop this from happening.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210915/e8e90ac2/attachment.htm>