Forum > Windows (32/64)
Lazarus Woes (4.2)
(1/1)
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:
--- Quote from: mellotronworker on March 04, 2026, 08:08:55 pm ---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.
--- End quote ---
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:
--- Quote ---fpspreadsheet.pas(25,31) Error: Cannot find avglvltree used by fpSpreadsheet, incompatible ppu=C:\lazarus\components\lazutils\lib\i386-win32\avglvltree.ppu, package LazUtils
--- End quote ---
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)
Navigation
[0] Message Index