Hi @ Wilders I have a Personal Finance software on my Windows Desktop which produces reports ONLY in CSV format. So each time I want to print out a report that looks "pretty" it involves a fair amount of formatting. To get round this I have produced an identical sheet in LibreOffice Calc in both xlsx and ODS format. Both have been formatted to "pretty" them up. What I am seeking to do is to copy the contents of my next CSV export and to overwrite the same content in the xlsx and ODS sheets, BUT I want to retain the formatting in the xlsx and ODS files. Is this possible and how do I do it? Thank you Terry
Not with CALC, maybe with Excel and a VB script. i consider even powershell not usable for this. ACCESS maybe can do this to convert data into another form and format cells. but... each office table sheet software is able to read data from another file, in excel it's (in german in only tell) "sverweis", "xverweis", "index" and similar. or very simple to read out a special cell. but... both documents are tied, if you lose source, then target is also lost in space. what else? xlsx is a compressed format, maybe xls uncompressed has to preferred. what else? a conditional format? but... my knowledge about excel is very limited, just started again for rare use, for me only i use softmaker office.
for excel and vbs/vba, with some usable results https://duckduckgo.com/?q=excel import csv vbs&ia=web https://duckduckgo.com/?q=excel import csv vba&ia=web for users new to vba/vbs it seems weird, i dealt 20 years ago with it. so i am complete off here. what i remember that sorting some kind of sheet data into another sheet do not alter formats.
