Description: I use libreoffice to open my excel Rotas at work, since updating they appear black and white and stripped of all formatting. Opening them in excel on the same computer still us all the border and colour fill information. Steps to Reproduce: 1.open my xlsx in libreoffice 2.compare to opening it in excel 3. Note the stark difference in formatting Actual Results: There is no border information or colour fill information as saved on Excel when opened in libreoffice Expected Results: It should have been able to reproduce the same formatting as on excel, simple border and colour fill information. Reproducible: Always User Profile Reset: Yes Additional Info: File attached
Created attachment 185956 [details] Xlsx rota
Created attachment 185957 [details] Image of the problem
Did this file open fine in any previous LibreOffice version? I tried in 7.2 and 7.5 and none of them showed any borders or background colors. In Excel the colors are there, so I'm setting this to NEW. Version: 7.2.6.2 / LibreOffice Community Build ID: b0ec3a565991f7569a5a7f5d24fed7f52653d754 CPU threads: 12; OS: Linux 5.19; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: threaded Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: 50(Build:2) CPU threads: 12; OS: Linux 5.19; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 4:7.5.1~rc2-0ubuntu0.22.10.1~lo1 Calc: threaded
No formatting either in: OpenOffice.org 3.3.0 OOO330m20 (Build:9567) I also tested a recent trunk build on Linux and Windows 10, and 7.3.0.3 on Windows 10, but could never see the formatting. I can confirm the sheet is formatted with borders and cell background colours throughout in: Microsoft® Excel® for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20186) 64-bit simpson.scott, are you sure you ever saw LibreOffice display the formatting on that file?
I’ve been using libreoffice to open these rotas that are made in Excel but always based on the same template. The only thing I can think of that’s changed has been I e updated to 7.5.1 from 7.3.5 but I’m not sure if it’s been entirely since updating. I don’t think there have been any other changes to libreoffice. Thanks
Yep, opened attached XLSX in Excel 2016. Formatting is all there. Verified missing colors/lines in: Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: CL threaded Definitely a strange one. - - - > I’ve been using libreoffice to open these rotas that are made in Excel but always based on the same template. Which version of Excel did you use to make this XLSX? And how did you set the template? - - - QA/Devs: Think it may be related to Bug #91276? (Accidentally[???] closed as "NOTABUG" back in 2015?) I was wondering where this bug's attached XLSX was getting colors from, saw the 2 files: - styles.xml --- Looks like THIS is what controls this file's fill/border colors. - theme1.xml Then randomly stumbled upon that closed 2015 bug while looking up: - fgColor site:https://bugs.documentfoundation.org/ - fills indexed xlsx site:https://bugs.documentfoundation.org/ (There was only 1 or 3 hits on the LO Bugzilla using those search terms.)
By template I just mean we have a master version of the file that we copy and rename for the week. Not sure what version of excel it was created with originally but we currently use Excel 19 to edit and save so this file was saved with Excel ‘19.
* Open attachment 185956 [details] with Calc. Save as xlsx with diff name. Open that. See additional borders, but not exactly the same as Excel displays on the original. * Open attachment 185956 [details] with Calc. click on cell E7 (colored in XL). ctrl+1 > BG color > already set to ffffff, same as typical "NONE" (auto) and same as typical BG page color (auto). Recently used colors in the same dialog shows the typical yellow (maybe same as seen in XL for E7), but IDK whether this is already saved in the xlsx file itself. I think we need the original template file, if that's possible, without any confidential info.
Created attachment 185976 [details] Rota template Template used for Rota, opens as expected without bug in 7.5.1