[Libreoffice-bugs] [Bug 136621] New: CALC INDIRECT() Function does not work correctly if local function separator for formulae is defined

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136621
           Summary: CALC INDIRECT() Function does not work correctly if
                    local function separator for formulae is defined
           Product: LibreOffice
           Version: 6.3.6.2 release
          Hardware: x86-64 (AMD64)
                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:
Swedish currency symbol is a colon : so local setting for formulae separators
is set to ; semicolon. Language interface is set to English - UK
When an INDIRECT() reference is defined within the SUM() function with the ;
separator it simply returns the individual value for the indirectly referenced
cell. If the : separator is used it returns the correct summation.
Simple spreadsheet "Indirect" attached to demonstrate.
It is an assumption that the error is within INDIRECT() as the chosen separator
performs correctly with all other SUM()functions

Steps to Reproduce:
In the attached sheet "Indirect"
Type any number between 1 & 18 in B1
C1 will create a target cell reference for column D
E1 contains the formula to SUM() D1>target using the semicolon ; separator
F1 contains the formula to SUM() D1>target using the colon : separator
Only one of them is correct


Actual Results:
E1 contains an incorrect result F1 contains a correct result

Expected Results:
As I had defined the separator to suit my local currency symbols I would expect
E1 to show the correct result but I am uncertain whether I should expect an
error message (502 or 504?) in F1.


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Version: 6.3.6.2 (x64)
Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: sv-SE (en_GB); UI-Language: en-GB
Calc: threaded

It may be one of those very esoteric issues that I'm now fully aware of and
obviously can make allowances to ensure the correct result.
The example is very simplistic, I am using the generated INDIRECT() reference
in a subsequent VLOOKUP()to define the parameters of a SUM()function. The
simple example is to prove it was the function separator misbehaving and
nothing wrong with my own syntax or sequences.
I have no perception of whether others are aware of the malfunction and simple
workaround, have never tried a similar construct, or have just abandoned the
effort in favour of a "blunt instrument" approach-

-- 
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/20200909/8f085fd0/attachment.htm>