[Libreoffice-bugs] [Bug 124224] New: FILESAVE XLSX Calculating with column labels doesn’t work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124224
           Summary: FILESAVE XLSX Calculating with column labels doesn’t
                    work
           Product: LibreOffice
           Version: 4.1.0.4 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

Description:
Calculating with column labels in XLSX documents created with LibreOffice Calc
6.3.0.0.alpha0+ doesn’t work when the document is opened in LibreOffice Calc
6.3.0.0.alpha0+.

Steps to Reproduce:
    1. Turn on Options – Calc – Calculate – Automatically find column and row
labels.
    2. Open the attached ODS file in LibreOffice Calc. It contains a column
label (that can be automatically found) in A1 and a formula =SUM('numbers') in
A10.
    3. Open the attached XLSX file in LibreOffice Calc. It was saved from the
ODS file.
    4. Type a value in the A8 cell in each document.
    5. Compare the A10 cells in ODS and XLSX file.
    6. View the attached screenshot.
    7. Notice, that in XLSX file the value of A10 cell doesn’t change.
    8. Opening the XLSX file in Excel gives “Part of this file is corrupted,
should we try to restore” error.

Actual Results:
Calculating with column labels doesn’t work when the document is opened in
LibreOffice Calc 6.3.0.0.alpha0+.

Expected Results:
Calculating with column labels doesn’t work should work the same way as the ODS
file when the document is opened in LibreOffice Calc 6.3.0.0.alpha0+.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.3.0.0.alpha0+
Build ID: 0faf4e5c2e98219b17e042594710f6872bf6a615
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded

Verzió: 5.0.0.5
Build az.: 1b1a90865e348b492231e1c451437d7a15bb262b
Területi beállítások: hu-HU (hu_HU)

Verzió: 4.2.0.4
Build az.: 05dceb5d363845f2cf968344d7adab8dcfb2ba71

Verzió: 4.1.0.4
Build az.: 89ea49ddacd9aa532507cbf852f2bb22b1ace28

But not with:
Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)

-- 
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/20190320/be3383aa/attachment-0001.html>