Convert to Csv via CLI and Update VLOOKUP file

asked 2015-11-21 13:49:03 +0100

paulSantone gravatar image

updated 2015-11-27 16:06:11 +0100

Hi, I have a xls with a link to external xls where pick the price If I open the master file and do Update, the prices are update, and I can do the CSV from GUI.

But If I do a CSV from CLI Like this:

"/Applications/LibreOffice.app/Contents/MacOS/soffice" --convert-to csv:"Text - txt - csv (StarCalc)":44,34,76,1 --outdir "/mypath/CSV_script" "my.xls"

My prices are all #N/A because they aren't link to a external file Can I do this operation from Cli ? Thanks

edit retag flag offensive close merge delete

Comments

Have you tried with the option Menu/Tools/LibreOffice calc/Formula - Recalculation on file load, setup for "Always recalculate"

m.a.riosv gravatar imagem.a.riosv ( 2015-11-30 00:00:06 +0100 )edit