Bug 133430 - Import cell styles from another spreadsheet
Summary: Import cell styles from another spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on: 49437
Blocks: Table-Styles
  Show dependency treegraph
 
Reported: 2020-05-27 09:46 UTC by NISZ LibreOffice Team
Modified: 2020-05-28 14:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel with a beautiful custom style (9.88 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-05-27 09:46 UTC, NISZ LibreOffice Team
Details
Screenshot of the dialog in Excel (56.32 KB, image/png)
2020-05-27 09:46 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2020-05-27 09:46:20 UTC
Created attachment 161317 [details]
Example file from Excel with a beautiful custom style

Excel has a feature for importing (custom) cell styles from another spreadsheet. It might be useful to have a similar feature in Calc too, since Writer already has.

Steps to reproduce:
    1. Create a custom cell style in Excel, save the file.
    2. Open a new spreadsheet and go to Cell Stlyes – Merge Styles.
    3. Select the previously created file to import the custom style.

Actual results:
No similar feature in Calc.

Expected results:
Style import dialog similar to Writers Styles -> Load Styles dialog.
Currently it is only possible to save a template with custom styles and then use that for new spreadsheets. 
Idea is that transferring nice styles from one file to another can be useful in one-off scenarios.

LibreOffice details:
Version: 7.0.0.0.alpha1+ (x64)
Build ID: b3c8859cd20bd02adea5d2b026001f67feacc754
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 1 NISZ LibreOffice Team 2020-05-27 09:46:42 UTC
Created attachment 161318 [details]
Screenshot of the dialog in Excel
Comment 2 BogdanB 2020-05-27 10:10:29 UTC
Confirm it is missing some import option.

Version: 6.4.4.2 (x64)
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: GL; VCL: win; 
Locale: ro-RO (ro_RO); UI-Language: en-US
Calc: threaded
Comment 3 Heiko Tietze 2020-05-27 10:17:57 UTC
Good idea, maybe via extension similar to https://extensions.libreoffice.org/en/extensions/show/custom-palette-eport.
Comment 4 Eike Rathke 2020-05-28 14:27:29 UTC
Fwiw, copying a cell that has a style assigned to another document copies that style along.