Dear all,
I’d like to report a particular “buggy” behavior from LO Calc that I do not see on other spreadsheet programs, such MS Excel, WPS, Google sheets.
When we use a text funcion such a match/index or even vlookup with an “open interval” (e.g. B:B instead of $B$2:$B$129$), and I copy it to multiple lines, LO Calc seems to look through the “infinite” lines and therefore becoming unresponsive, and the calculation really takes very long to be completed.
In my daily basis I use the match/index function to make stock / sales / product information sheets to speak to each other, and this LO behavior is quite annoying as to achieve a good performance I have to fixate all the intervals, where I’m used to just inform the column label on other spreadsheets software.
I am using the attached spreadsheet as an example (this is a real example from my job).
I prepared two example columns, where we can copy the formula from D2 to D129 on the ledger tab, and this would just work with good performance (it calculates within a second).
If we do the same from B2 to B129, it will also calculate correctly, however it takes around a minute on my laptop, and the Operationa System thinks the software has crashed.
Am I missing something here, or this is something we could report as a bug / improvement to be done?
Thank you all for your time.
The best,
PS:
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 8; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: pt-BR (pt_BR.UTF-8); UI: pt-BR
Flatpak
Calc: threaded
Index-Match example.ods (22.2 KB)