https://bugs.documentfoundation.org/show_bug.cgi?id=155551
Bug ID: 155551
Summary: Open interval vs “fixed” interval for index/match or
lookup function
Product: LibreOffice
Version: 7.5.3.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: gis...@protonmail.com
Description:
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
I uploaded an example file at:
https://ask.libreoffice.org/t/open-interval-vs-fixed-interval-for-index-match-or-vlookup/91992
Steps to Reproduce:
1. Create a with single entries containing spaces after it and one attribute to
it, e.g. Reference "A ", description X
2. In another tab, spread some different references, A, B, C etc
3. Use a match/index to search descriptions such X as a Match of trimmed A etc
Actual Results:
If we use a trim function and do not fix the lookup interval, CALC seems to
search on the entire number of lines, taking too much time and sometimes
crashing
Expected Results:
Work with equivalent performance as with the "trim" function
Reproducible: Always
User Profile Reset: No
Additional Info:
I uploaded an example file at:
https://ask.libreoffice.org/t/open-interval-vs-fixed-interval-for-index-match-or-vlookup/91992
--
You are receiving this mail because:
You are the assignee for the bug.
