Summary: | Calc - Change font of whole sheet does not work and has side effects | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | robert |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | heiko.tietze, miguelangelrv, robert, stephane.guillou |
Priority: | medium | ||
Version: | 7.5.3.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | ODS file exhibiting the problem |
Description
robert
2023-05-18 21:44:46 UTC
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 *** |