Bug 82654

Summary: FILESAVE, FILEOPEN: style name prefixed with "Excel Built-in"
Product: LibreOffice Reporter: Markus <mbarchfe>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: major    
Priority: medium CC: qubit
Version: 4.2.3.3 release   
Hardware: Other   
OS: All   
Whiteboard:
i915 platform: i915 features:
Attachments: Spreadsheet showing the prefixing of the style name

Description Markus 2014-08-15 08:08:48 UTC
Created attachment 104658 [details]
Spreadsheet showing the prefixing of the style name

Hello,

When saving a spreadsheet to xlsx and then reopening it, the name of custom styles are prefixed with "Excel Built-in".


Steps to reproduce:

1) Create a new Spreadsheet
2) Create a new style (e.g. via "New Style from Selection), name it "MyStyle"
3) Save the document as xlxx
4) Close the Document
5) Open the document again
=> Now the Style appears in the list of styles as "Excel Built-in MyStyle", whereas before save/load it was named "MyStyle"

Attached you find a sample spreadsheet.
Comment 1 Robinson Tryon (qubit) 2014-08-16 02:17:00 UTC
CONFIRMED on LO 4.3.1.1 + Ubuntu 12.04

(In reply to comment #0)
> 1) Create a new Spreadsheet
> 2) Create a new style (e.g. via "New Style from Selection), name it "MyStyle"
> 3) Save the document as xlxx

Saved as XSLX.

> 4) Close the Document
> 5) Open the document again
> => Now the Style appears in the list of styles as "Excel Built-in MyStyle",
> whereas before save/load it was named "MyStyle"

Confirmed.

Even if the format is XLSX, I don't think we'd need to rename the style to match the name 'Excel': The OOXML format should be vendor neutral (I think...)

Thanks for reporting this bug!
Comment 2 Urmas 2014-08-18 16:54:14 UTC
In master:
The first custom style is saved as 'customized Explanatory Text';
All other custom styles are silently lost (but present in styles.xml)

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.