Lazarus Woes (4.2)

[mellotronworker]

I feel like I am losing my mind trying to make LAZARUS (v4.6) do even the simplest thing.

I need a program to write spreadsheets out from a given data set. fpSpreadsheet seems to be the answer. I tried to use FPC but of course fpSpreadsheet needs to be compiled under Lazarus.

I have downloaded Lazarus, installed it clean and used only the defaults.

It of course fails as there is no fpSpreadsheet installed within Lazarus. I download and install it through the online package manager, then rebuild the IDE.

It still cannot find fpSpreadsheet. It was installed to [AppData]\Local\lazarus\onlinepackagemanager\packages\FPSpreadsheet\source\common. So I point the project's 'additional folders' at this location. (This seems like an incredibly long winded approach - why does that setting (a) not take top level wildcards such as [AppData]\Local\lazarus\onlinepackagemanager\* and why on earth does it not include that as a default that it knows about already?)

It still fails to compile:

fpspreadsheet.pas(25,31) Error: Cannot find avglvltree used by fpSpreadsheet, incompatible ppu=C:\lazarus\components\lazutils\lib\i386-win32\avglvltree.ppu, package LazUtils

'Build' produces the same error. The source is indeed inside "C:\lazarus\components\lazutils"

What on earth is going on? This all seems stupidly complicated.  I've just installed it from scratch and would hope that libraries would compile!!

[n7800]

fpSpreadsheet is a "package". To use packages in your project, need to specify a dependency on them. Then your project will compile in any IDE, no matter where it's downloaded.

Open "Menu > Project > Project Inspector", click the "Add" button, select "New Requirement" and find "fpSpreadsheet".

Now you can add the any package units to the usage section, and the project should compile.

[n7800]

It of course fails as there is no fpSpreadsheet installed within Lazarus. I download and install it through the online package manager, then rebuild the IDE.

What should be included in the Lazarus distribution itself is a complex question. In any case, it won't contain every possible package, so sometimes you still have to download them via OPM ((

[Martin_fr]

fpspreadsheet.pas(25,31) Error: Cannot find avglvltree used by fpSpreadsheet, incompatible ppu=C:\lazarus\components\lazutils\lib\i386-win32\avglvltree.ppu, package LazUtils

Means that FpSpreadsheat was found.

Ignore the PPU part: https://gitlab.com/freepascal.org/lazarus/lazarus/-/issues/42063 It may be wrong.

It is possible that
1) FpSpreadsheat does not correctly include LazUtils.

2) The new Lazarus is in a new location, but uses the config of the old, and therefore seeks LazUtil in the wrong place.
The IDE remembers were it has last seen a package.
Try opening all involved packages from the "open package file" => browse to the *.lpk file, and open it.


I noticed its for 32 bit  => is that intentional (ok, if it is, but as 64 bit is more common, just making sure)