https://bugs.documentfoundation.org/show_bug.cgi?id=173220
Bug ID: 173220
Summary: =sum function does not work when the cells being added
up are links to cells on a second sheet
Product: LibreOffice
Version: 26.2.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This function returns a value of zero rather than the actual sum of the values.
I am using the function: =SUM(AR32:AR37) Where each of the cells contains a
reference to a cell on another sheet. For example in cell AR32 the value
specified is =$'From Fidelity'.H12, where the other sheet is labeled 'From
Fidelity'. The value displayed in cell AR32 is correct and is the amount
$37256.44. Again, on that other sheet, the value entered is $37256.44. Inorder
to get the correct value I had to substitute the 'sum' function with the
following: =AR32+AR33+AR34+AR35+AR36+AR37 In this case the formula correctly
adds the values from the cells on the other sheet.
Steps to Reproduce:
See details described in Description field above
Actual Results:
See details described in Description field above
Expected Results:
See details described in Description field above
Reproducible: Always
User Profile Reset: No
Additional Info:
See details described in Description field above
Version: 26.2.4.2 (X86_64)
Build ID: 0229ac93fcf0d7cbc6376066c6f35021cef002dc
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Vulkan;
VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
