Bug 82654 - FILESAVE, FILEOPEN: style name prefixed with "Excel Built-in"
Summary: FILESAVE, FILEOPEN: style name prefixed with "Excel Built-in"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.3.3 release
Hardware: Other All
: medium major
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-15 08:08 UTC by Markus
Modified: 2014-08-18 16:54 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:


Attachments
Spreadsheet showing the prefixing of the style name (4.41 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2014-08-15 08:08 UTC, Markus
Details

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.