Some problems with examples
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
backprop · 2024-09-05 03:42

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

----------------------------------------------------------------------
backprop · 2024-09-05 03:45

ooxmldemo: Can't be compiled.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i         if
(pos('file:', target) = 0) and FileNameIsAbsolute(target) then
FileNameIsAbsolute is unknown function.

----------------------------------------------------------------------
backprop · 2024-09-05 04:09

excel5write:

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

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
MyWorksheet.WriteColWidth(0, 40);
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i Warning:
Symbol "WriteColWidth" is deprecated: "Use version with parameter
AUnits"
And that need to be cleaned how. I have not found exact explanation.

----------------------------------------------------------------------
backprop · 2024-09-05 04:12

Etc, I just tried these two examples for now.

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

----------------------------------------------------------------------
cdbc · 2024-09-05 04:48

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 · 2024-09-05 06:00

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 · 2024-09-05 08:43

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

Quote from: backprop on September 05, 2024, 05:45:41 amooxmldemo:
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.

Quote from: backprop on September 05, 2024, 06:09:50 amexcel5write:

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

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i  
MyWorksheet.WriteColWidth(0, 40);
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i 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 · 2024-09-07 15:19

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 · 2024-09-07 15:51

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).

Quote from: backprop on September 07, 2024, 05:19:40 pmexaples 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).