Recent

Author Topic: Error loadind xlsx file  (Read 1506 times)

dvigor

  • New member
  • *
  • Posts: 5
Error loadind xlsx file
« on: January 27, 2022, 06:24:13 am »
Hi,

I am loading an XLSX file using the LoadFromSpreadsheetFile function.
LoadFromSpreadsheetFile(UTF8ToSys(excel File.FullFileName), sfidUnknown, 0);

And I get an error. Please help me understand why.

<Version Major="1" Minor="12"/>

file: https://drive.google.com/file/d/1Zm1NOkOcYETBazDGWAD5M4_VbGv4Ye-M/view?usp=sharing
screen: https://drive.google.com/file/d/188AT4TTnj4YSaBa58jLDntfJxMWnnggL/view?usp=sharing

Thank you.

Update:
screen 2: https://drive.google.com/file/d/1mlVY1xwPxbq0tdkYGue-kSbtO6o6tPvp/view?usp=sharing

« Last Edit: January 27, 2022, 07:00:24 am by dvigor »

wp

  • Hero Member
  • *****
  • Posts: 9571
Re: Error loadind xlsx file
« Reply #1 on: January 28, 2022, 12:02:53 am »
I analyzed the file and get the following formula in cell D2 of the error sheet
Quote
IF(COUNTIF(ОЖФ_Множ,$A2),"Да","Нет")

According to documentation the first argument of the COUNTIF function is the cell range to be analyzed by the formula. FPSpreadsheet expects here a simple cell range expression, such as A1:D4. But you give the name of a range - cell and range names, however, are not supported by FPSpreadsheet, sorry.
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...

dvigor

  • New member
  • *
  • Posts: 5
Re: Error loadind xlsx file
« Reply #2 on: January 28, 2022, 05:13:40 am »
It's clear.
Thanks a lot.

 

TinyPortal © 2005-2018