https://bugs.documentfoundation.org/show_bug.cgi?id=99053
Bug ID: 99053
Summary: Absolute and relative cell references produce
unexpected results when using summation function
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/49.0.2623.110 Safari/537.36
Build Identifier: LibreOffice 5.1.0.3
In Calc, the summation function gives incorrect results, depending on whether
absolute or relative cell references are used. Details appear on the affected
spreadsheet. The problem seem related to my earlier bug report 98966.
Reproducible: Always
Steps to Reproduce:
1.See attached spreadsheet (if requested):
2.Place cursor in (for example) cell I840
3.Cycle function key F4, note incorrect results in cell I840
4.Move cursor to another cell in column I, repeat cycling and observe result
Actual Results:
1.Cell I840 is initially correct in the file as saved, but becomes wrong when
F4 is cycled.
2. With only cell I840 selected, ENTIRE column I is affected by cycling F4
Expected Results:
1.Cell I840 should sum to 12
2.Cycling F4 should not alter the value (12) and should not affect all of
column I
[Information automatically included from LibreOffice]
Locale: en-US
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Reset User Profile?No
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
