Bug 85101 - FILEOPEN: *.xlsx weird characters in defined names not supported in formulas
Summary: FILEOPEN: *.xlsx weird characters in defined names not supported in formulas
Status: CLOSED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
 
Reported: 2014-10-16 16:48 UTC by VLB
Modified: 2018-07-24 17:53 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
issue file (11.25 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-10-16 16:48 UTC, VLB
Details
issue file (11.25 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-10-16 16:53 UTC, VLB
Details

Note You need to log in before you can comment on or make changes to this bug.
Description VLB 2014-10-16 16:48:53 UTC
Created attachment 107937 [details]
issue file

LO 4.3.2.2 windows 7 64 bit

Step to reproduce:
1 i have a file in *.xlsx
2 save as *.ods
3 formula in cell D17 and J15 is destroy (please find attach)
Comment 1 VLB 2014-10-16 16:53:53 UTC
Created attachment 107938 [details]
issue file
Comment 2 Eike Rathke 2014-10-16 17:33:41 UTC
This is not on filesave, apparently it happens already on load, at least the formulas in D17 and J16 are already broken then. These use weird characters in names, such as  s┴_1  or  t║_2  as can be seen in the raw xl/worksheets/sheet1.xml stream, that seem not to be supported in formulas.
Comment 3 m_a_riosv 2014-10-16 21:02:11 UTC
The only broken is definition for 's' used in D17 and J16.

Looking into the attached file xl/workbook.xml contents defined names but not for 's', at least I can't see it.

After defining 's' defining it in Manage names, saving and reopen seems to works fine, and definition name for 's' in in xl/workbook.xml.

Don't seems a LibreOffice bug.
Comment 4 Eike Rathke 2014-10-17 17:48:41 UTC
It's not the problem that the name 's' is not defined, the 's' is only a result of a truncated name in the formula.

There are three weird names defined in xl/workbook.xml
<definedName name="s┴_1">Blad1!$B$16</definedName>
<definedName name="t║_2">Blad1!$B$15</definedName>
<definedName name="t┴_1">Blad1!$B$14</definedName>

Formulas in xl/worksheets/sheet1.xml are:
in J16: s┴_1/D16
in D17: (s┴_1^2+3*(t┴_1^2+t║_2^2))^0.5
Comment 5 tommy27 2016-04-16 07:23:38 UTC Comment hidden (obsolete)
Comment 6 VLB 2016-04-16 15:20:01 UTC
I have test with version 5.1.2.2 (x64) windows and the bug is still present.
Comment 7 Eike Rathke 2016-05-06 11:51:22 UTC
Of course, accepting characters that are not letters or digits (plus a few others) in names is not implemented. Why use box drawing characters in names anyway? I wonder why Excel allows them and what their allowed subset actually is. This exception is nowhere mentioned in https://support.office.com/en-us/article/Define-and-use-names-in-formulas-4D0F13AC-53B7-422E-AFD2-ABD7FF379C64#bmsyntax_rules_for_names

I tend to close this as wontfix.
Comment 8 QA Administrators 2017-05-22 13:40:30 UTC Comment hidden (obsolete)
Comment 9 VLB 2017-05-22 17:19:13 UTC
The bug is still present in LO 5.3.3.2 (x64) Win 10.
Comment 10 QA Administrators 2018-07-24 02:36:48 UTC Comment hidden (obsolete)
Comment 11 Eike Rathke 2018-07-24 17:53:08 UTC
Wontfix notourbug as per comment 7. That document is already broken as by the definition mentioned there.

Mere assumption: the document was created with a tool or Excel version that treated some 8-bit localized character encoding badly and wrote the names as broken UTF-8. The seven or so occurrences can be fixed manually in the original document's sheet1.xml stream.