<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - CALC INDIRECT() Function does not work correctly if local function separator for formulae is defined"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136621">136621</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>CALC INDIRECT() Function does not work correctly if local function separator for formulae is defined
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>that.man.colin@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>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-</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>