I have a complex Numbers.app spreadsheet which contains a table with cells that are colored with different background colors. The different colors represent essential information.
When I export the table to a CSV file in numbers (File > Export to… > CSV…) the color information is not included in the exported CSV in any way. That is a problem for me, since it is essential information.
Is there anyway to include the cell background color information in a CSV export? Of course I want to retain and export all of the other usual information in the CSV export as well. Any workaround which can export this color information in any kind of structured format would be acceptable/interesting to know.
Note: I did notice that this cell background color information is preserved when exporting to Excel format (File > Export to… > XLS…). If there is no more direct way, I would love to also hear about an option to first export to Excel, and then export from Excel to a CSV format which somehow includes the structured color information.
Also Note: Yes, of course I am aware that CSV is a text-only file format. But out-of-band info could theoretically be included in an export in some kind of format like hex_color_value:text_value for each cell (comma-separated value). Something like that would really be ideal…