[Libreoffice-bugs] [Bug 131424] New: FILEOPEN XLSX Table reference broken if table header contains comma

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131424
           Summary: FILEOPEN XLSX Table reference broken if table header
                    contains comma
           Product: LibreOffice
           Version: 7.0.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Keywords: filter:xlsx
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: nemeth at numbertext.org

Created attachment 158809
  --> https://bugs.documentfoundation.org/attachment.cgi?id=158809&action=edit
Example file from Excel

User made Excel table contained a Table, with some simple formulas referring to
the table headers. 
One of these headers contained a comma, which confused Calc and made Err:507
errors.

Steps to reproduce:
    1. Open attached XLSX file. Note the Table in it, and in B1 the header is
“This is the,second column” with a comma.
    2. In Excel the C column contains a simple addition formula, referring to
table rows and headers by name.
    3. This is converted in Calc incorrectly, causing Err:507 messages in the C
column.

Actual results:
The formula is converted to this: 
=MyTable1[[#This Row],[This is the first column]]+MyTable1[[#This Row],[this is
the,second column]]
The comma in the second column header confuses Calc, but removing it from B1
and from the formula, then changing back the first letter to be capital fixes
the calculation
With localized UI the problem is more visible. In localized UI the “#This Row”
specifier is normally translated, but after a comma in column header, it’s no
longer. 
Also the comma is changed to semicolon in the formula: “this is the;second
column”

Expected results:
Correct calculation.

LibreOffice details:
Version: 7.0.0.0.alpha0+ (x64)
Build ID: ec85ed21a960a198a01778cdb89a91fabcb5d0c0
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: GL; VCL: win; 
Locale: en-US (hu_HU); UI-Language: en-US
Calc: CL

Also happens in:
Verzió: 6.0.0.3
Build az.: 64a0f66915f38c6217de274f0aa8e15618924765
CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: GL; 
Területi beállítások: hu-HU (hu_HU); Calc: CL

Version: 5.0.0.5
Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b
Locale: hu-HU (hu_HU)

Err:509 in: 
Version: 4.4.0.3
Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7
Locale: hu_HU

and earlier, back to 3.5.0rc3

-- 
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/20200319/b3ec5db9/attachment.htm>