https://bugs.documentfoundation.org/show_bug.cgi?id=151651
Bug ID: 151651
Summary: Error in recalcling values resulting in faulty display
with void data. maybe problems with INDIRCT and/or
ADDRESS / Err:522
Product: LibreOffice
Version: 7.4.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 183160
--> https://bugs.documentfoundation.org/attachment.cgi?id=183160&action=edit
picture shows the faulty display / error
There is an error, which I still not found a way to reproduce, but come across
very often (either after opening a file or while switching between different
sheets).
I created a spreadsheet calculating a list of all Champions League winners, and
sort them regarding their amount of appearance.
I made two screenshots which show my problem:
1) error appears
2) “one solution” to correct the error by unhiding some cells
In 1) you can see the error. In 2) you can see the correct display. And between
them, I just unhid some cells.
But this is only one way. Another way to correct the display is by edit
something - most times (not always!) the display changes to show the correct
values.
I have a feeling that this could be connected to the INDIRECT and ADDRESS
functions which I use in this spreadsheet.
The error also occurs in other spreadsheets I created and used INDIRECT and
ADDRESS.
In my opinion Err:522 is misleading, because it simply doesn't fit in this
case.
P.S. unfortunately, I can only add one screenshot, so I decided to add the
error appearance
--
You are receiving this mail because:
You are the assignee for the bug.
