Page 1 of 1

Advance invoice demo error

Posted: Sun Aug 27, 2017 5:11 pm
by Zohar
Hello i have compiled Advance invoice demo without problems in Delphi 7 with lastest version XLSSpreadSheet. but when i open advance invoice i select excel filename to save and click on "Create Worksheet" it show error " E4020: Missing argument for function "IF(2)" ". need help please

Another question is about PDF export, how i export PDF? there is no instruction or sample code

Re: Advance invoice demo error

Posted: Sun Aug 27, 2017 9:18 pm
by larsa
Hello

I can't reproduce this.

Here is what I do:

1. Click "Create worksheet".
2. Click "Find & Replace Cells".
3. Select Excel Filename, click "..."
4. Click "Save to File".

Regarding PDF export, please take a look at the XLSSpreadSheet/Advanced sample and the menu File->Export->PDF

Re: Advance invoice demo error

Posted: Sun Aug 27, 2017 11:01 pm
by Zohar
Thanks for the reply, I have removed the formulas from code and i got no more error on create worksheet.

I didnt found the Advanced sample, where is this? is not in the sample folder

Re: Advance invoice demo error

Posted: Mon Aug 28, 2017 6:46 am
by larsa
Hello

Sorry, this sample was missing, but this is fixed now. Please download the component again.