https://bugs.documentfoundation.org/show_bug.cgi?id=154215
Bug ID: 154215
Summary: The WeekNum worksheet function is very slow
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: junkyardma...@frontier.com
Description:
More than 1000x > than Excel
Steps to Reproduce:
1. Run the code in the other information section.
2.
3.
Actual Results:
12 seconds for 10K WeekNum() calls (> 1ms per)
More than 1000x > than Excel
Expected Results:
Reasonably close to Excel performance (< 10x)
0.101 seconds for 10K WeekNum() calls
Reproducible: Always
User Profile Reset: No
Additional Info:
Option VBASupport 1
Sub WeekNum_Function_Performance()
Dim T1 As Single
Dim T2 As Single
With WorksheetFunction
T1 = Timer()
For i = 1 To 10000
WkNum = .WeekNum("03/14/2023", 1)
Next i
T2 = Timer()
End With
MsgBox ("Iterations: " & i & ", Time: " & T2 - T1)
End Sub
--
You are receiving this mail because:
You are the assignee for the bug.
