Keep frozen cell status on CSV files, or scripted open process?

[jcorbett]

Hi - I have a few CSV files I regularly open in LibreOffice for my work. As CSV files dont save things like like what cells are frozen, I always have to do the same process of freezing first row, freezing first column every time I open one. And one of them I need to freeze the first three columns.

This is a bit annoying to have to do every time. Is there a way I can speed up this process? Perhaps some default behaviour when opening a CSV to always freeze first row and column? Or maybe some kind of script that will do it for me when opening specific documents, or even a script that could open, say, the three I most regularly use and apply the freezing I want to them?

I should add I am not really a coder so writing something in python or suchlike may be way beyond me.

Thanks!

[fpy]

@jcorbett

kind of script

worth spending 20 min to get familiar with the basics, like in Chapter 13 Getting Started with Macros
or from numerous tutorial videos.

then just copy from : BASIC+Calc: How to Freeze Rows and Columns

[Steph1]

You could use the concept of template. Make a blank Calc document with the frozen rows and columns as you like, then use the menu option File > Templates > Save as template.
When you need to open a csv for which you want to freeze the first three columns, simply use the corresponding template, which will open a blank document at the right format, then copy/paste your csv file content in it.

[Lupp]

Let’s open our eyes a bit wider.

• For the very special case presented here the advantages of a solution can never pay for the amounbt of time used to write the needed user code.
• After all it’s extremely simple to select a single cell and to activate a menu item then.

More generally: If a user wants to open some frequently needed files regarding specific parameters depending on the type / the size / the something, they may use a spreadsheet document as a kind of “Call_A_Pizza”.
The mentioned files (designated by their paths) may then be collected case-dependent in sheets providing a functionality similar to the “folders” or “search results” of a file system, but with user defined-options.
In the given case (and also for ods) only two parameters are named, and the solution is rather simple. Allowing for enhanced sets of parameters additional programming is needed.
My example is presented as a Calc template, but any document derived from it will also contain the code and can be used independently.
experimentalOpenCsvFreeze.ots (16.3 KB)
As with every downloaded file containing macros: Be careful and check the macros for the absence of malign code before you permit usage.