0
votes
0answers
27 views

OpenOffice Calc convert with command line

I am trying to convert xls to dbf with OpenOffice Calc via command line (Windows), but I'm getting an error with this line (path is set): scalc --invisible -convert-to dbf c:\MATIKGL.xls Error : ...
1
vote
1answer
1k views

How to convert text to decimal in openoffice calc?

I have a column which contains: € 53,28 € 1.336,0 € 69,90 € 296,50 € 899,00 € 149,90 € 697,40 and so on. I want to sum the column up, but for openoffice it is text and not a decimal. What I did: ...
3
votes
1answer
3k views

Ubuntu: Convert OpenOffice Calc to Excel workbook using CLI

I need to create an automated report in a spreadsheet format. Unfortunately, There seems to be an easy way to create these reports using OpenOffice Calc, but upper managements wants them in MS Excel ...