Advance invoice demo error

[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]

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

[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]

Hello

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