Description: Calc mixes up styles in Excel 2003's XML format. The styles from one declaration seem to bleed over into other declarations and affect other cells. Steps to Reproduce: 1. Create a new spreadsheet in Excel. 2. Apply a selection of different styles to different cells (e.g. one bold, one with background colour, one with borders) 3. Save as Excel 2003 XML format 4. Open in LibreOffice Actual Results: Some of the styles bleed over and apply to other cells incorrectly. Expected Results: The spreadsheet should look the same as it does in Excel. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: This bug has existed for as far back as I can remember (at least as far back as LibreOffice 4), and has been observed on many different machines and distributions.
Created attachment 174536 [details] Original file generated by our software. Cells should not be grey
Created attachment 174537 [details] report_ig.xml opened in Excel and re-saved (with extra blue cells added). Calc now incorrectly shows all cells with thick borders
Created attachment 174538 [details] New file created with Excel. Each cell should have a different style, Calc shows all cells with brown background.
repro in Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community Build ID: bc7baa18435000f47f90e47d3300710bcb4cf56b CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL
The build from the current master branch (slated to become 24.2) has the latest version of orcus 0.19.2 and does a much better job of importing the styles from the documents attached to this bug.