[To Discuss] Do we need to conserve the Google Sheet formatting?

[SomeoneInParticular]

As the title implies, all information from the Google Sheet is imported as-is. This includes text and cell formatting (i.e. whether the text is bold, or whether a cell is colored yellow), which, as far as I can tell, is not used in any of the analyses.

If this is the case, by stripping this information we could substantially reduce the space taken up by the Google sheet cache on user's computers (XLSX is notorious for being bloated in part due to this); that being said, I'm not the one editing the Google sheets or determining how they should be used. Could someone who is validate what these formatting marks mean, if anything? Thank you

[SomeoneInParticular]

@jcohenadad I suspect you know the most about this; apologies for the explicit tag.

[jcohenadad]

i'm not sure i understand-- the gsheet has no formatting (or not supposed to)-- do you have an example?

[SomeoneInParticular]

Oh, sorry, should have clarified. I meant stuff like text and cell formatting (i.e. bold text, cell coloration etc.).

For example:

To be fair, this seems to be one of the only entries with non-textual formatting, but wanted to be certain before stripping it during caching

[jcohenadad]

leave it as yellow in the gsheet-- stuff i need to modify but didn't have time yet-- ignore when importing