Import using libreOffice calc

Hi

Hoping for some help. I am trying to import objects from an xlsx file. The objects_idno is a composite of year and number, eg 14 = 2014 and 10 = item 10. In the spreadsheet I have tried about all the combos to generate something like 14:0010 or 14.001 etc. On import I get the formula and not the result. The only entries that seem to work are those where no formula is involved.

Also this warning

Warning: A non-numeric value encountered in /var/www/ca/vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/Date.php on line 140

CA Version = 1.7.16

php version = 7.4.32

OS = ubuntu 22.04.1 LTS (jammy)

libreOffice (calc) = 7.3.6.2

My thoughts were that a Joiner might be the answer in the mapping file but could not find any documentation on how to use.

New to the game and thanks in advance, Buzz

Comments

Sign In or Register to comment.