Import using libreOffice calc
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) = 220.127.116.11
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