I have a directory of csvs. I want to give them the same template. Primary requirement is a category column, which must be given a different background colour for each of a different range of possible values.
I followed these steps:
. created template
. created a conditional formatting for each of the 10 possible categories
. opened csv, copied all contents, pasted into template (as so instructed by openoffice help pages)
I expected that this would insert the csv values into the pre-formatted spreadsheet, giving me a list of categories with background colours derived from their values.
But this didn’t happen. Instead, it copied plain-formatted cell data into the template, effectively erasing the conditional formatting.
How do I quickly and easily transform my csvs into formatted ods spreadsheets?