Bug 106604 - FILEOPEN VIEWING - Opened XLS-File is not displaying superscript correctly
Summary: FILEOPEN VIEWING - Opened XLS-File is not displaying superscript correctly
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency treegraph
 
Reported: 2017-03-17 19:44 UTC by nenad.steric
Modified: 2019-03-24 13:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
the xls with the offending superscripts (2.39 MB, application/vnd.ms-excel)
2017-03-17 19:45 UTC, nenad.steric
Details
comparison MSO 2010 and LibreOffice 5.4 (87.53 KB, image/png)
2017-03-18 14:22 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nenad.steric 2017-03-17 19:44:06 UTC
Description:
an imported xls File is displaying supercripts as if they are part of the baseline.

e.g. 
instead of 8 with superscripts 1,2
Calc displays the value "812"

Which is *very* bad if you need the correct value for medical treatment.




Steps to Reproduce:
1.
Go to http://eucast.org/clinical_breakpoints/
open 
"Breakpoint table for bacteria"
use the link for the xls 
to see the correct rendering you can use the pdf link

http://www.eucast.org/fileadmin/src/media/PDFs/EUCAST_files/Breakpoint_tables/v_7.1_Breakpoint_Tables.xls

(I will try to attach the file to the bug)

2.
go to e.g. Sheet "Enterobacteriaceae" 

3.
e.g. Ampicillin-sulbactam should display 8 with superscripts 1,2
instead it looks like it has the value "812"



Actual Results:  
812

Expected Results:
8 with superscript 1,2


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 nenad.steric 2017-03-17 19:45:57 UTC
Created attachment 131968 [details]
the xls with the offending superscripts
Comment 2 Xisco Faulí 2017-03-18 14:21:43 UTC
Confirmed in

- Version: 5.4.0.0.alpha0+
Build ID: d3b5bd4a07a619db6bee1c39c32280ac3c620532
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); Calc: group

- Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

- LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 3 Xisco Faulí 2017-03-18 14:22:07 UTC
Created attachment 131986 [details]
comparison MSO 2010 and LibreOffice 5.4
Comment 4 nenad.steric 2018-03-02 22:29:54 UTC
can confirm this also for 

Version: 6.0.2.1 (x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 4; OS: Windows 10.0; UI render: GL; 
Locale: de-AT (de_AT); Calc: CL