Hello
just wanted to add some interesting content. I’ve landed on this question since one invoices calc “program” that ever worked, after a recent update, didn’t worked anymore.
The invoice items (prodotti) lines were using this formula
=SE(VAL.VUOTO(C23);" ";CERCA.VERT(C23;Prodotti;CONFRONTA("Price";$Prodotti.$A$1:$AMJ$1;0);FALSO()))
I’m sorry, but the sheet is made with LibreOffice Italiano
SE = IF
VAL.VUOTO = Empty (vuoto) Value (val) (returns true if that cell is empty)
CERCA.VERT = Vertical Lookup (I don’t know the English version, maybe it is VLOOKUP)
CONFRONTA = Compare
FALSO = False
in the Prodotti sheet, there are just 4 columns, which the headers were: Description, Price, Discount %, VAT
Well “VAT” was working while “Price” and “Discount %” were not anymore.
The current question topic on ask.libreoffice.org, gave me the inspiration to turn the columns names to UPPERCASE and it came back to work again O_o??
As first step, thank to this topic/question, I’ve noticed that the issue was fixed by replacing the headers names with their corresponding cell coordinates e.g. instead of “Prices” I could have use Prodotti.B1
=SE(VAL.VUOTO(C23);" ";CERCA.VERT(C23;Prodotti;CONFRONTA(Prodotti.B1;$Prodotti.$A$1:$AMJ$1;0);FALSO()))
But that was tricky, since trying to select and drag the fixed cells, the Prodotti.B1, would have become Prodotti.B2, Prodotti.B3 etc
Is that the point where I had the inspiration and so
I ended up with editing the 4 columns names from
Description, Price, Discount%, VAT
to
DESCR, PRICE, DISC, VAT
It works
Cheers
Robert @ Recupero Dati Hard Disk 299