Hello all
I’m looking to a way to “save” the setting I do for some csv file
I have a few number of csv file which are used by some process, and I need to edit them several time per day
Each time, I have to select the file, then in the “Text Import” window, select all columns and set them to “Text” (I had some issues with “Standard”), then press “OK”
When done, the file open in Calc, so I select all the columns (more than 20) then right-click, → “Column Width…” → tick “Default Value” → Ok
Then select row 8, → Menu View → Freeze Cells → Freeze Rows and Columns
Then I can start to work
If you do that once from time to time, it’s OK, but 5 or 10 times per days , it’s annoying (and I can’t keep the file open !!)
Ideally, I would like to find an extension or a macro which will recognize the file I selected and will do all the repetitive tasks for me
And if it can do it for more than one file (not all the same settings) , that will be perfect
Do you know something which can help me ?
Best regards
ericc