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?
Thanks!