https://bugs.documentfoundation.org/show_bug.cgi?id=146454
Bug ID: 146454
Summary: Calc: setDataArray with the strings is very slow in
7.3.0.1
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: kam...@post.cz
Only run this macro, it opens new Calc file and puts the strings to the 100k
rows in column A. It is very slow in 7.3.0.1.
Sub SlowSetDataArray
const c=100000
dim oDoc as object, oSheet as object, i&, data(c), oRange as object
oDoc=StarDesktop.LoadComponentFromUrl("private:factory/scalc",
"_Blank", 0, array()) 'new file
oSheet=oDoc.Sheets(0)
for i=0 to c
data(i)=array(CStr(i)) 'speed tragedy, about 40 seconds; but in
7.2.4.1 it is OK, about 1 second
'data(i)=array(i) 'fast, OK, about 1 second
next i
oRange=oSheet.getCellRangeByPosition(0, 0, 0, c)
oRange.setDataArray(data)
End Sub
bugged:
Version: 7.3.0.1 (x64) / LibreOffice Community
Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d
CPU threads: 8; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: cs-CZ (cs_CZ); UI: cs-CZ
Calc: CL
OK in:
Version: 7.2.4.1 (x64) / LibreOffice Community
Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9
CPU threads: 8; OS: Windows 10.0 Build 17763; UI render: Skia/Raster; VCL: win
Locale: cs-CZ (cs_CZ); UI: cs-CZ
Calc: CL
--
You are receiving this mail because:
You are the assignee for the bug.
