[Libreoffice-bugs] [Bug 144294] New: CALC *URGENT* probably fatal failure of the internal file structure =IFERROR(IF(SEARCH(F$1; $C5)<1; ""; 1); "") now returns incorrect values

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144294

            Bug ID: 144294
           Summary: CALC *URGENT* probably fatal failure of the internal
                    file structure =IFERROR(IF(SEARCH(F$1;$C5)<1;"";1);"")
                    now returns incorrect values
           Product: LibreOffice
           Version: 7.2.0.4 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: that.man.colin at gmail.com

Description:
I have only recently upgraded to this current release. The formula identified
above has functioned as expected for up to 3500 cells on almost 500 iterations.
Taking a simple growth factor of half of the 3500 cells, that's 875,000 success
units. It can't be my fault.
When upgrading to the current release, the user profile was cleared and reset.
I omitted to set the parameter for formulae to adjust to their new sort
location. Clearly, this parameter is required as eXcel seems unable to "follow
the plot" so we have to either dumb it down for compatibility or set the
parameter to allow us to utilise the inherent superiority of LO.
When I first processed a sheet with the latest version which had originally
been saved under the older version with the "follow me" enabled, I hadn't
noticed the parameter wasn't set nor the impact upon the results - and saved
the file. This implied that "follow me" was also not correctly saved with the
latest file. Subsequently, processing another file I realised the sort was
"screwed" and set the parameter to "follow me". Today, I updated the sheet and
the result was clearly incorrect as a statistical improbability had occurred -
I thought it was unusual last week but not exceptionally so.
Upon inspection of the attached screen dumps you can see that the earlier saved
formula returns the correct result but the later saved identical formula
returns pure gibberish.
I'm sure you can figure the formula but for the record, it just tests the
string to establish the existence of the source value and flags it with a "1".
If you can find a correct match in the later sheet's formulae then I'm
seriously deluded.
Fortunately, It only recently "bombed" so hopefully, I will be able to rebuild
the analysis by simply reprocessing a couple of weeks' data in a previously
saved version with the parameter corrected in the current software. "Hopefully"
being the operative word. If the later version still can't deal with it then
the problem is even greater than imagined as I can't reprocess 7 years of data.
I would be forced to "fall back" to an earlier version and then reprocess the
data.
It is a simple matter to provide the original sheets in their full form if that
is of assistance in analysing and comparing the internal structures.
Also, as the autofilters cannot sort according to any user-defined "sort
sheets" I have built a little index into column M which assigns a numerical
value to the user sort criteria and this value is extracted from a simple
VLOOKUP.
I sort and select the analysis on these requisite values in column M 

Steps to Reproduce:
As described, I saved a sheet with an older version and formulae following
parameter set and reopened it in a later version without setting that
parameter.
Having saved the updated sheet it is now apparent that a tried and tested
function no longer functions.
It's impossible for a user to define whether it's a sorting error, a function
error, a file save error or a user profile error - but a profile error would be
a failure of LO to utilise the amended profile on a later sheet.
2.
3.

Actual Results:
Incorrect value assigned 

Expected Results:
Correct value to be assigned


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 4; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210904/e96aa70e/attachment-0001.htm>