Advance invoice demo error

Questions and answers on how to use XLSSpreadSheet.
Post Reply
Zohar
Posts: 2
Joined: Sun Aug 27, 2017 4:59 pm

Advance invoice demo error

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Advance invoice demo error

Post 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
Lars Arvidsson, Axolot Data
Zohar
Posts: 2
Joined: Sun Aug 27, 2017 4:59 pm

Re: Advance invoice demo error

Post 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
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Advance invoice demo error

Post by larsa »

Hello

Sorry, this sample was missing, but this is fixed now. Please download the component again.
Lars Arvidsson, Axolot Data
Post Reply