[Libreoffice-bugs] [Bug 127887] New: Cell references off by 256 when importing wk1 Lotus 1-2-3 spreadsheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127887
           Summary: Cell references off by 256 when importing wk1 Lotus
                    1-2-3 spreadsheet
           Product: LibreOffice
           Version: 6.0.7.3 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jabugz at fastmail.com

Description:
The attached wk1 spreadsheet contains the formula +A301 in cell A6.  When
opened by Calc, cell A6 displays the value of cell A301, but its formula is
=A45.  When the value in A45 is changed, A6 displays A45's value.

The wk1 spreadsheet also contains the formula +A300 in cell A5.  When opened by
Calc, cell A5 displays 0 even though cell A300 contains "ALPHA TEST".  A5's
formula is =A44.

In contrast, Gnumeric 1.12.35 correctly opens the wk1 spreadsheet.  The formula
shown for cell A6 is =A301 and the formula shown for A5 is =A300.  Cells A6 and
A5 correctly display the values of A301 and A300 respectively.

Steps to Reproduce:
1.Open the attached wk1 spreadsheet
2.
3.

Actual Results:
Observe that the formulas in A5 and A6 are =A44 and =A45 respectively.

Observe that A6 displays 100 until a different value is entered in A45.

Expected Results:
The formula shown for cell A6 is =A301 and the formula shown for A5 is =A300. 
Cells A6 and A5 correctly display the values of A301 and A300 respectively.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 6.0.7.3
Build ID: 1:6.0.7-0ubuntu0.18.04.10
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group


The problem was also observed in Calc on Windows, with LibreOffice 6.3.3.2
(x64)

-- 
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/20190930/986e86de/attachment-0001.html>