https://bugs.documentfoundation.org/show_bug.cgi?id=90042
Bug ID: 90042
Summary: Inserting a lot of string in cells is solw
Product: LibreOffice
Version: 4.4.1.2 rc
Hardware: PowerPC
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 114133
--> https://bugs.documentfoundation.org/attachment.cgi?id=114133&action=edit
sample document with macro to reproduce
* context
- a "big file" containing 500 sheets, 300 formulas per sheet, 15k named ranges
- a macro loops over namedranges, modifie the value of each one and copy 3 new
cells per row
* result
such an heavy process has become very slow. it now takes around 1400 seconds to
process
first analysis using callgrind leads to +80% of time spent in
http://opengrok.libreoffice.org/xref/core/sc/source/core/data/document.cxx#3229
that lead to looping over sheets/columns/cells each time
http://opengrok.libreoffice.org/xref/core/sc/source/core/data/column3.cxx#1582
a more refined callgrind trace to come ...
* attachment
the sample document. Hit the the "Go !" button and say ok to the warnbong that
th eprocess may take some time
The duration is givent at the end of the process (in second)
do not forget to enable macros before opening
--
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
