Convert to Csv via CLI and Update VLOOKUP file

[paulSantone]

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

[mariosv]

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