Ask Your Question

[Calc] Changing font not working. [Picture]

asked 2020-09-17 14:25:24 +0100

Zakalwe gravatar image

image description

So I even have custom styles for the cells which is supposed to set the size, but some cells are just not being affected by it or select-all + apply font change, to fix it I have to mass-change the front size drastically like this so I can find the 'broken' cells, and manually change the font in them, then they start responding to mass-changes and styles again (I think, so far).

This seems to be a known bug for years from what I can tell via google.. is there a fix or anything anywhere? do they know it exists?

edit retag flag offensive close merge delete


Well, what about Ctrl+M (Clear Direct Formatting) and after that "apply font change" (apply cell style will be better)

JohnSUN gravatar imageJohnSUN ( 2020-09-17 14:47:07 +0100 )edit

If you change the text attributes of part of the cell content in edit mode (e.g. bold in "Piston - Cyma"), applying styles would not change these direct format applied attributes.

LeroyG gravatar imageLeroyG ( 2020-09-17 15:32:16 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-09-17 16:25:43 +0100

Zizi64 gravatar image

updated 2020-09-17 16:26:15 +0100

Your attached image shows that the Styles are overwritten some manual formatting properties (a part of the string is bold, and an other part is not.)

The Cell Styles can format a whole cell only, but not the parts of the cell contents. The overwritten properties will not refresh, when you change the style of the cell. It is a normal behavior, and not a bug.

And maybe some cells are protected...

Please upload a real .ods sample file here - instead of the picture. Then we will able to examine it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-09-17 14:25:24 +0100

Seen: 41 times

Last updated: Sep 17