I receive a csv file which I convert into Calc sheet.
I would like to display the columns in a different order, not linearly modified, calling this MySheet.
I should like to be able to sort my sheet version by 1 to 3 criteria, and I usually use the Autofilter.
Are there function in Calc to apply? No macros, I can not handle these.
The option of manually modify is known to me, the first column is C, the last is R. Quite some work. for each file received.
If you have to repeat this often, consider to create a data-source in Base. A database of type text is just a folder containing your csv-files. (Actually you select the folder when you define the “database”.).
.
Then you can create queries with your order of columns and drag this to Calc. Calc remembers this, so you can always refresh data
(I use a filename “current.csv” for this) from the menu in Calc.
.
Depending on your needs, you can also do some pre-sorting or filtering in the query, but I assume you will prefer the autofilter in Calc.
Sorry to ask, I should have recognized the solution.
After inserting the data in the table add a row on top of it where the sort order should be entered as a number. What is to be first column receives “1”, what is to be 10th column receives “10”. All columns need a number, better no duplicates.
When done sort full table horizontally guided by the the row holding the entered numbers.