https://bugs.freedesktop.org/show_bug.cgi?id=68615
--- Comment #20 from Markus Mohrhard <[email protected]> --- (In reply to comment #19) > @Markus: this might be interesting for you ;-) > > Loading the document allocates ~7GB of memory, which on Windows given that > the application is 32-bit leads to an out-of-memory abort. > > The document contains a tremendous amount (5311) of table-cell styles of > which most have 10 <style:map> elements that except the > style:base-cell-address attribute are identical. Apparently for each cell a > separate conditional style is present. > > The document seems to originate from Excel as 24 of the <style:map> elements > have a style:apply-style-name='Excel_5f_5f_5f_...' where the name is 24586 > (!) characters long with _5f repeated all over, making up three different > styles ending in ..._1, ..._2 and ..._3. These names are also used once each > in a <calcext:condition calcext:apply-style-name='...'>. Yes. The conditional formatting is a problem. The old cell based conditional formatting was able to deal with this and in newer builds we should be able to import the old document much better. The proiblem is that this document has been stored with Libreoffice before I switched to a more intelligent conditional formatting merge strategy. In current builds we should merge all equal conditional formats into one conditional format with a large range( what the original document most likely had as well ). The old calc core made one conditional format per cell out of it while the new conditional format code should merge them if the document does not yet contain new conditional format information. The best thing for this document is tore it once with an old version and then import it into 4.1(I'm not sure which version already contains my changes) or later. That should produce much better conditional formatting which makes editing the document faster and more user friendly. Currently I have no better idea how we can improve the handling of this file. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
