Hi Larry! I apologize for the delay in getting back to you, work has been keeping me very busy. Just wanted to let you know that your workaround works perfectly! After adding "null" on row #2 the formatting is kept. I can successfully see my template in both Libre Office and Microsoft Office. Thanks a lot!! (owe u beer!) Cheers
Thank you Larry! Finishing some work now and I will test this either today or tomorrow. Will get back to you with the results. Best regards,
As always Larry, thank you for taking the time of building and maintaining this great tool! Was creating some new reports and for the first time tested the results in Office 2016 (I've been always using Libre Office) and realized that with Microsoft's product the format is lost after the csv content is dumped into the xlsx template. Libre Office: everything is fine, the final xlsx file has the header, font, size, centered, etc (so it preserves the entire formatting that I defined on my xlsx template)....
Hey larry, not sure whether u saw my last message on this topic. Just checking :)...
It works now with the new version! Thanks Larry !!!
Ok so just tried with v2.06 and got the same error :( csv2odf -t 1 -c ";" "$FILE_CSV1_FINAL"...
Ok so just tried and it worked with v2.06 but it overwrited column's A text with...
Ok so just tried and it worked with v2.06 but it overwrited column's A text with...