Some problems with examples

[backprop]

I order to get familiar with, I have started to test some examples. But some problems raised...

[backprop]

ooxmldemo: Can't be compiled.

Code: Pascal  [Select][+][-]

1.         if (pos('file:', target) = 0) and FileNameIsAbsolute(target) then

FileNameIsAbsolute is unknown function.

[backprop]

excel5write:

Can be compiled, but some obsolete functions are shown when tried to be uses accordingly:

Code: Pascal  [Select][+][-]

1.   MyWorksheet.WriteColWidth(0, 40);

Code: Pascal  [Select][+][-]

1. Warning: Symbol "WriteColWidth" is deprecated: "Use version with parameter AUnits"

And that need to be cleaned how. I have not found exact explanation.

[backprop]

Etc, I just tried these two examples for now.

Since the code is 9 years old, some revisions is welcome.

[cdbc]

Hi
I think, you need a newer version of 'fpspreadsheet', must be out there somewhere, because I know @wp has worked on it recently ~ couple of weeks ago...
Regards Benny

[backprop]

Well, the code is practically the same as that 9 years ago. And result is very poor on KDE Linux.

Old code for excel5write example gives much better results than this new one...

[wp]

Please specify your Lazarus/FPC and FPSpreadsheet versions. Where did you get FPSpreadsheet from?

ooxmldemo: Can't be compiled.

Cannot confirm. Tested back until Laz 2.0.12 / FPC 3.2.0; Laz 2.0.8 / FPC 3.0.4 does not compile FPSpreadsheet svn version because the chart module requires generics.

excel5write:

Can be compiled, but some obsolete functions are shown when tried to be uses accordingly:

Code: Pascal  [Select][+][-]

1.   MyWorksheet.WriteColWidth(0, 40);

Code: Pascal  [Select][+][-]

1. Warning: Symbol "WriteColWidth" is deprecated: "Use version with parameter AUnits"

And that need to be cleaned how. I have not found exact explanation.

These functions are not "obsolete". The "deprecated" attribute is a warning to the user that these functions will be removed in a future version and give a hint on how to avoid compilation issues when that happens. Nevertheless, they should be avoided in the current release.

[backprop]

The package is from OPM, exaples are from there and some online GIT repository from 9 years ago which can be found online.

Lazarus is 3.2, FPC 3.2.2.

Definitely I', searching for clean a proper examples.

[wp]

Installed FPSpreadsheet from OPM into Laz 3.2.0/FPC 3.2.2 (Win 11, 64bit). No problems with ooxmldemo/excel5demo write/read projects (The output file of the excel5write demo has the row height issue that you mention, but this is because autorowheight is not applied in this version of the demo. It is fixed in the unreleased svn version, though).

exaples are from [...] some online GIT repository from 9 years ago which can be found online.

FPSpreadsheet is hosted in an svn repository, rather than git. Therefore, this certainly is not an official demo. Contact the author and notify him about the issue(s).