fill_color returns white #392

Activity

1. darkBuddha commented on Jan 7, 2022

   

   darkBuddha

   on Jan 7, 2022

   Last edited by darkBuddha

   More actions

   It's the same for me, on another sheet. It is #d9d9d9. I guess, grayscales are saved white, and their "brightness" gets reduced, in a separate value.
2. kikuhama commented on Jul 31, 2023

   

   kikuhama

   on Jul 31, 2023

   More actions

   I found same probrem.
   It seems that the fill color specified by index (not RGB) is ignored and fill_color method returns 'ffffff'.
3. Lukom commented on Oct 25, 2023

   

   Lukom

   on Oct 25, 2023

   Last edited by Lukom

   More actions

   I found out the same – indexed colors are ignored.. I've composed such helper method to check color AND indexed color:

   class RubyXlUtils
     class << self
   
       def cell_color(cell)
         return unless cell
         color = cell.workbook.get_fill_color(cell.get_cell_xf)&.then { _1.last(6).downcase }
         if color == 'ffffff'
           color = cell_indexed_color(cell) || 'ffffff'
         end
         color
       end
   
       def cell_indexed_color(cell)
         if (fill_id = cell.get_cell_xf.fill_id)
           if (color_index = cell.workbook.fills[fill_id].pattern_fill&.fg_color&.indexed)
             if (indexed_color = cell.workbook.stylesheet.colors&.indexed_colors&.dig(color_index))
               indexed_color.rgb.last(6).downcase
             end
           end
         end
       end
   
     end
   end

   👍React with 👍1Reacted by weshatheleopard