Adding new sheets to excel
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
Davidous · 2021-01-15 11:43

Hello!

I have an interesting problem now. I do excel-programming from lazarus
for years now. When I want to add a new sheet, I use the formula
"E.Sheets.Add(After:=E.Sheets[E.Sheets.Count]);". Until now it worked
perfectly.
Today I compiled my program and at this row I get the error message
that you can see on the attached picture. What am I doing wrong?
Thank you in advance!

Best regards,

David

----------------------------------------------------------------------
PascalDragon · 2021-01-15 11:58

Quote from: Davidous on January 15, 2021, 12:43:37 pmI have an
interesting problem now. I do excel-programming from lazarus for years
now. When I want to add a new sheet, I use the formula
"E.Sheets.Add(After:=E.Sheets[E.Sheets.Count]);". Until now it worked
perfectly.
Today I compiled my program and at this row I get the error message
that you can see on the attached picture. What am I doing wrong?
Thank you in advance!
What compiler version do you use? Did you change compiler version?
There was a problem with named parameters in 3.2.0 that should be
fixed in 3.2.1, so if possible please test with that.

----------------------------------------------------------------------
Davidous · 2021-01-15 12:49

Hello,

I couldn't find a link for version 3.2.1., but I downloaded version
3.0.4. and it solved my problem.
Thank you very much for your help!