Page 1 of 1

Spreadsheets always receive standard cell styles

Posted: Thu Feb 22, 2018 11:59 am
by mus
I have a nice corporate XLSX table where i carefully deleted (in MS Excel) all of the unnecessary cell styles, leaving nothing but my custom styles and the undeletable "normal" style.

As soon as i open this document in OO, it silently 1) replaces my custom "normal" with a default and to make things worse, 2) it adds all of these unnecessary and, frankly, ugly cell styles ("accent 1...6, currency etc") that i just removed in excel.

Even worse, they appear on top of the list (while Excel places custom styles first), making a simple change of styles a matter of multiple clicks (heck, still can't add a keyboard shortcut for that, can we?)
screenshot annoooyance.png
screenshot annoooyance.png (135.77 KiB) Viewed 922 times

This is part of a larger problem where (i posted this before) in a mixed environment where a file is both edited in oo and MS Office, you can never be certain that oo doesn't silently change, add or delete things (Videos in PPT? conditional formatting? Images on spreadsheets?) in the document. I am depressed this can't be remedied.

Re: Spreadsheets always receive standard cell styles

Posted: Tue Mar 06, 2018 8:01 am
by Maxim
Hello mus!
Please can you attach this file to analyze?

Re: Spreadsheets always receive standard cell styles

Posted: Thu Apr 12, 2018 5:01 pm
by mus
Sure. Here it is.
1) open it in excel (mac). It will show only these styles:
excel.png (89.29 KiB) Viewed 712 times
. Note that the custom styled are at the top of the list, which makes sense.
2) open it in OO (i used 4.8.8 Desktop and 5.1.1 self hosted). The list of styles is expanded as described above. My custom styles are at the end of a list with about 47 distracting entries.