Ask Your Question

How endow multiple csv files with spreadsheet template + conditional formatting [closed]

asked 2014-12-11 14:34:03 +0200

shee-eet gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 01:22:46.407163

1 Answer

Sort by » oldest newest most voted

answered 2014-12-11 19:28:24 +0200

m.a.riosv gravatar image

updated 2014-12-11 19:29:06 +0200

Being possible link to a csv file like any other spreadsheet.
Open the formatted spreadsheet.
Open the CSV file.
with both visible, go to the first cell in the formatted file for link data.
Enter = and with the mouse click on the cell in CSV file, Enter to finish.
Copy the formula with the link where you need, or do it with an array link covering the whole range.
Update in Menu/Edit/Link - update.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-12-11 14:34:03 +0200

Seen: 149 times

Last updated: Dec 11 '14