Result of formula calculation doe not changed. Changes only syntax (text) of formula
Steps to Reproduce:
1. Run LibreOffice calc
2. Enter following formulas to A1 cell:
3. Enter following formulas to A2 cell:
4. Save and close the file, and reopen it
5. Observe result in A2 cell
User Profile Reset: Yes
OpenGL enabled: Yes
Version: 18.104.22.168 (x64)
Build ID: dc68ad6c5cde3c62874b96422f2e5e8252499bad
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: en-US (en_US); Calc: CL
(In reply to Andrey from comment #0)
> Result of formula calculation doe not changed. Changes only syntax (text) of
> Steps to Reproduce:
> 1. Run LibreOffice calc
> 2. Enter following formulas to A1 cell:
> 3. Enter following formulas to A2 cell:
> 4. Save and close the file, and reopen it
> 5. Observe result in A2 cell
> Actual Results:
> Expected Results:
Why do you use "," for separation of arguments? You should use ";" for that
it doesn't matter, issue reproduced for all types of separators.
(In reply to Andrey from comment #2)
> it doesn't matter, issue reproduced for all types of separators.
I can't repro with ";".
Created attachment 143931 [details]
(In reply to kompilainenn from comment #3)
> (In reply to Andrey from comment #2)
> > it doesn't matter, issue reproduced for all types of separators.
> I can't repro with ";".
Sorry about music, I forgot about it -_-
I can repro. In a sense it is logical: if you leave a tracing , or ; Calc thinks you forgot something. So it fills the default value for reference (Abs).
Yet, this does not happen with, for example, MATCH.
In 3.3.0, the ADDRESS result is Err:511.
In 3.6.7 it behaves like today.
Arch Linux 64-bit
Build ID: 1c59d021b3dd27c8c0255312bd0d53ad25965bab
CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5;
Locale: fi-FI (fi_FI.UTF-8); Calc: threaded
Built on September 1st 2018
ABS(1,1,) has an empty omitted 3rd argument, which is semantically equivalent to ABS(1,1,1). As Buovjaga noted, older releases could not handle the omitted argument, thus it is stored as 1 for backward compatibility. Not a bug.