Error loadind xlsx file
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
dvigor · 2022-01-27 05:24

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/188AT4TTnj4YSaBa58jLDntfJxMWnn
ggL/view?usp=sharing

Thank you.

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

----------------------------------------------------------------------
wp · 2022-01-27 23:02

I analyzed the file and get the following formula in cell D2 of the
error sheet
QuoteIF(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.

----------------------------------------------------------------------
dvigor · 2022-01-28 04:13

It's clear.
Thanks a lot.