Bug 122100 - FILEOPEN XLSX, $ symbols are missing from conditional formatting when opened in LO.
Summary: FILEOPEN XLSX, $ symbols are missing from conditional formatting when opened ...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.0.beta1+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency tree / graph
 
Reported: 2018-12-14 12:04 UTC by NISZ LibreOffice Team
Modified: 2018-12-18 15:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
The original spreadsheet. (502.47 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2018-12-14 12:05 UTC, NISZ LibreOffice Team 		Details
Screenshot of the original document side by side in Excel and Calc. (368.54 KB, image/png)
2018-12-14 12:05 UTC, NISZ LibreOffice Team 		Details
I can't reproduce it in LibreOffice 6.3 master (19.34 KB, image/png)
2018-12-18 13:57 UTC, Xisco Faulí 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2018-12-14 12:04:35 UTC 
Description:
When the attached spreadsheet is opened in LO the $ symbols are missing from the conditional formatting range.

Steps to Reproduce:
    1. Open the attached spreadsheet in MSO.
    2. Open conditional formatting→ Manage rules and check page Munkatárs.
    3. Open the attached spreadsheet in LO.
    4. Go to the page Munkatárs and select all(Ctrl+A).
    5. Format→ Conditional→ Manage→ Check the range.

Actual Results:
The $ symbols are missing from the range in LO.

Expected Results:
They should stay the same as they were in MSO.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2018-12-14 12:05:24 UTC 
Created attachment 147533 [details]
The original spreadsheet.
Comment 2 NISZ LibreOffice Team 2018-12-14 12:05:44 UTC 
Created attachment 147534 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 3 Roman Kuznetsov 2018-12-15 09:49:13 UTC 
confirm in

Version: 6.3.0.0.alpha0+
Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 4 Xisco Faulí 2018-12-18 13:57:31 UTC 
Could you please clarify what '$ symbols are missing' means? I see them, please see attached image...
Comment 5 Xisco Faulí 2018-12-18 13:57:53 UTC 
Created attachment 147649 [details]
I can't reproduce it in LibreOffice 6.3 master
Comment 6 Gabor Kelemen (allotropia) 2018-12-18 15:16:40 UTC 
(In reply to Xisco Faulí from comment #4)
> Could you please clarify what '$ symbols are missing' means? I see them,
> please see attached image...

It's in the Range field of Calc, and "Érvényesség" (Validity) in Excel.
However upon closer examination it seems to be only a difference in display of values, and we were unable to identify any real problems caused by this.
Sorry for the noise.