Description: When changing the font of one of the sheets of the attached "lift & v100+.ods", in casu the "Waiting info" one, the first six characters in cell J7 will not be changed, but remain Segoe UI. Also, once the font is changed to "Source Code Pro Light", licking a single cell and bolding it will bold every cell of the sheet. Steps to Reproduce: 1. Open the attached "lift & v100+.ods" 2. Select the "Waiting info" sheet 3. Select the entire sheet, Ctrl-A 4. Select the new font, "Source Code Pro Light" (or for that matter, "Courier New" or "Arial", the result is the same) 5. Put the pointer on cell J7 and see that the first six characters are still "Segoe UI" 6. Select any single cell in this sheet, and click on "B(old)" (or "I(talic)" or U(nderline)" and every cell will change Additional: On two occasions, also changing other sheets to use "Source Code Pro Light", Bolding, Italicizing, and Underlining completely stopped working, but I cannot reproduce this behaviour again. Actual Results: The font in cell J7 is only partially changed Expected Results: Cell J7 should change in its entirety, bolding a single selected cell should not affect the whole sheet Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: CL threaded Starting in Safe Mode does not correct the problem!
Created attachment 187385 [details] ODS file exhibiting the problem
*** This bug has been marked as a duplicate of bug 153527 ***
You formatted the cell explicitly like this. Check the content.xml inside the ods (which is a zip). <table:table-cell table:style-name="ce47" office:value-type="string" calcext:value-type="string"> <text:p><text:span text:style-name="T2">W ></text:span><text:span text:style-name="T3">=</text:span><text:span text:style-name="T4"> </text:span><text:span text:style-name="T5">W</text:span> + 3SD</text:p> </table:table-cell> <style:style style:name="T2" style:family="text"> <style:text-properties style:font-name="Segoe UI" fo:font-size="12pt" fo:font-weight="normal" style:text-underline-style="none" style:text-underline-color="font-color" style:text-line-through-type="none" fo:font-style="normal" style:text-outline="false" fo:text-shadow="none" style:text-line-through-mode="continuous" fo:language="en" fo:country="GB" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color"/> </style:style> Removing all direct formatting per ctrl+M first does the trick.
There's actually two issues here. (In reply to robert from comment #0) > 5. Put the pointer on cell J7 and see that the first six characters are > still "Segoe UI" This issue I can reproduce in your example file since OOo 3.3, so it is inherited. I believe this is due to some direct formatting applied to a part of the string, which is the same issue as described in bug 39969. > 6. Select any single cell in this sheet, and click on "B(old)" (or > "I(talic)" or U(nderline)" and every cell will change This is linked to more recent bug 153527, as m.a.riosv pointed out. It started in 7.5. Heiko, I think it's more appropriate to mark as a duplicate of bug 39969, for the inability to overwrite direct formatting on parts of cell contents when many cells are selected, as many are not satisfied with the workaround given the loss of other formatting. *** This bug has been marked as a duplicate of bug 39969 ***