Stars Missing on Conditional Formatting

asked 2017-03-06 18:48:12 +0200

newuser2017 gravatar image

updated 2020-07-10 22:06:10 +0200

Alex Kemp gravatar image

I created a spreadsheet in Calc for my book collection list and two of the columns are for the rating (the first is the number, e.g. 1, 2, 3, etc. and the second is the star rating conditional formatting that I set up using the 3 star icon set.) I have it working fine expect that I noticed that not every star is appearing like it suppose to. For example, I have a book that I read and gave a four star rating to. It shows the four stars in yellow but not the fifth one in gray (similar to Goodreads star ratings). But I noticed that it only seems to do that on some but not all. Some will have all of the stars visible while others will not.

Is there something I can do to fix this issue?


edit retag flag offensive close merge delete


Please share a sample file with the issue.

m.a.riosv gravatar imagem.a.riosv ( 2017-03-06 22:46:53 +0200 )edit