Recent

Author Topic: Adding new sheets to excel  (Read 231 times)

Davidous

  • Jr. Member
  • **
  • Posts: 82
Adding new sheets to excel
« on: January 15, 2021, 12:43:37 pm »
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

  • Hero Member
  • *****
  • Posts: 2751
  • Compiler Developer
Re: Adding new sheets to excel
« Reply #1 on: January 15, 2021, 12:58:54 pm »
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!

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

  • Jr. Member
  • **
  • Posts: 82
Re: Adding new sheets to excel
« Reply #2 on: January 15, 2021, 01:49:56 pm »
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! :)

 

TinyPortal © 2005-2018