I have requirements for a spreadsheet save which may be mutually exclusive, of if they are not, at least I am not aware how to resolve them. My requirements are these:
- export number strings with leading zeroes
- export with cell colors which flag areas in need of attention
Achieving the first, the only approach I found was save without format info. I assume, however, that format info is required for cell coloring in the spreadsheet. If I export with formatting info, is there a way to also ensure the leading zeroes are intact?