https://bugs.freedesktop.org/show_bug.cgi?id=82414
Priority: medium
Bug ID: 82414
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILESAVE: R1C1 notation is not preserved and ranges do
not appear to sum as expected
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: owen.ge...@gmail.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.4.0.0.alpha0+ Master
Component: Spreadsheet
Product: LibreOffice
Created attachment 104376
--> https://bugs.freedesktop.org/attachment.cgi?id=104376&action=edit
ODS showing before and after cell range notation under LOv4400 2014-08-08
Problem description: This report relies on using Multiplan / Lotus-123 / Excel
R1C1 notation. I am raising the bug to get confirmation / clarification of:
a) Whether certain cell range references should be preserved as entered or if
it is OK for Calc to change the entered cell range reference between save,
close, and re-open of the ODS.
b) Whether the included cell range references using R1C1 notation are
considered valid.
I am happy to raise a separate bug if it becomes apparent there are two
separate issues. I have raised this report due to this forum thread:
http://en.libreofficeforum.org/node/6199
... where a long-time user of R1C1 notation is indicating problems in recent
versions of Calc. I have included the thread for reference only as it does not
include much in the way of a simple or clear example (hence this report).
The attached ODS contains numbers 1 to 3 in rows 1 to 3 across 4 columns. Each
column of figures is summed using a different type of cell range notation:
R[-3]C:R[-1]C - column 1
R[-1]C:R[-3]C - column 2
R[-3]C:RC - column 3
RC:R[-3]C - column 4
It is not clear to me which are valid forms from the old Multiplan / Lotus-123
/ Excel days, but each would appear at least understandable. For convenience I
have displayed each formula (as entered) on row 5, labelled "before". Beneath
this in row 6 (labelled "after") is what each cell in row 4 contains after
saving, closing, and re-opening of the ODS.
Steps to reproduce:
1. Tools > Options... > LibreOffice Calc > Formula > set Formula syntax to
"Excel R1C1".
2. In a new file enter the numbers 1,2,3 in rows 1,2,3 respectively.
3. Copy these across 4 columns.
4. Beneath each column enter one of the indicated types of cell range reference
in a SUM() function e.g., in R4C1 enter =SUM(R[-3]C:R[-1]C) in R4C2 enter
=SUM(R[-1]C:R[-3]C) and so on.
5. Note values displayed are: 6, 0, Err:522, and 0 (most of which seem
erroneous).
6. Save the file (ODS).
7. Close file.
8. Re-open file.
Current behavior: Contents of R4C2 and R4C4 are altered and resultant sums
displayed are different (6, 6, Err:522, Err:522).
Expected behavior: Entered values are preserved and range references add as
expected.
Tested under Crunchbang 11 x86_64 using v4.4.0.0.alpha0+ Build ID:
4d635dcae4d7275d04a17a0efc11b0531d5d0a82
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time:
2014-08-08_23:24:32.
Behaviour is the same under these versions also:
- v4.2.6.2 Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f
- v4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0
Under v4.1.6.2 Build ID: 40ff705089295be5be0aae9b15123f687c05b0a the initially
entered cell range still reverts after save, close, re-open, but the initially
displayed values do not change i.e., 6, 6, Err:522, Err:522. This would seem to
indicate at least a change in calculating the resultant value during the v4.2
series.
Operating System: Debian
Version: 4.4.0.0.alpha0+ Master
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
