Description: I have a Calc - spreadsheet that has alternating shaded rows, and all rows are set to have the same font and size, but as you use the sheet, it appears the font on the shaded rows appear much smaller than the unshaded. I'll enclose a pic, and a shot of the spreadsheet. Steps to Reproduce: 1.Alternately shade your spreadsheet 2.See the results, with any font, as you resize the data 3. Actual Results: They should render the same Expected Results: They do not Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Created attachment 199896 [details] Print of what the spreadsheet looks like, with highlighted example Not a killer bug, but one that should be addressed, thank you!
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Here you go....
Created attachment 199907 [details] sample of spreadsheet
Seems the issue, is the 'ConditionalStye_1' having a font size of 11, used by Calc to set up the cell height. But it doesn't affect the cells with a date format, which maintains the number and font format, that looks it was a direct format not and style format. Some behaviors under conditional format are a bit tricky mixed with direct formats. Version: 25.2.2.1 (X86_64) / LibreOffice Community Build ID: 38d746d66d9b82fa248a2e90142b9dd3ddd1d6cd CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
I'm using Format - Autoformat Styles. Would you think I need to format the cells differently, perhaps directly, to get the alternate shading and get the font to appear as it should? Thanks
That autoformat are direct formats on the cells. Using a copy of the file. Test: Put the CF in a range outside the data range. Clean the direct formats Menu>Format>Clear direct formatting [Ctrl+M] Change the CF range and text, how it works. Maybe a format for the cells with dates is needed.
So, I played with it, and fixed it with conditional formatting using: Format -> Conditional -> Condition... Condition 1: Formula is ISEVEN(ROW()) Apply Style But Shouldn't the built in autoformat respect the font choices?
This issue has been fixed in release 25.2.2.2 Thank you!!
Works for me, based on comment 9.