Named range

[backprop]

Adding "Named range" is not supported?

That is very useful if possible to create. For now, using template file may be solution, but anyway.

[wp]

This is available in the current svn version (https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/fpspreadsheet/), not yet released to OPM.

[backprop]

When is planned to be released?

[wp]

When the remaining issues with the chart module are solved.

[backprop]

ATM, I'm not interested for charts, thus if that only missing, I will definitely try SVN version as I need named ranges functionality ASAP.

If there is any example, would be great.

[wp]

There is a write and a read sample project in folder examples/other/defined_names.

[backprop]

I just recompiled SVN and when intended to install visual package, some error shown:

Code: [Select]

Unable to find file "datetimepicker.pas".
If it belongs to your project, check search path in
Project -> Compiler Options -> Search Paths -> Other Unit Files. If this file belongs to a package, check the appropriate package compiler options. If this file belongs to Lazarus, make sure compiling clean. If the file belongs to FPC then check fpc.cfg. If unsure, check Project -> CompilerOptions -> Test

It is strange, as I do not use datetimepicker, probably not the lib as well. The same error is shown when I wanted to install ATSynedit.

[wp]

This is an issue that you installed Lazarus in a way that you do not have sufficient write permissions. Please search the forum for "datetimepicker" - there are several threads about this issue.

When you only want to read/write spreadsheet files you do not need the visual components (they are for displaying); in this case, it is sufficient that you open the laz_fpspreadsheet.lpk package so that the IDE knows where it is.

[backprop]

This is an issue that you installed Lazarus in a way that you do not have sufficient write permissions.

Funny, since I have no idea how to install deb files except with sudo dpkg command. There is some other issue here.

Perhaps some dev lib missing which depends on distro to distro and release to release. I never seen deb Lazarus and FPC files are distributed with all dependencies required. Always something missing.

[backprop]

This is available in the current svn version (https://sourceforge.net/p/lazarus-ccr/svn/HEAD/tree/components/fpspreadsheet/), not yet released to OPM.

What is current status of this?

Long time was passed from time this is posted...

[dbannon]

Addressing your previous question, dating back to 2024 backprop.

Funny, since I have no idea how to install deb files except with sudo dpkg command. There is some other issue here.

Perhaps some dev lib missing which depends on distro to distro and release to release. ...

The command you need is sudo apt install ....

Or, if you prefer, apt-get in more recent distributions.

The dpkg command is not intended for use the way you think and using it to install will usually fail because it does not address dependencies.

Davo

[Thaddy]

It is the other way around regarding apt and apt-get but that does not matter because one is an alias/symlink to the other. They are not fully separate binaries., a bit like we have fpc and ppcxxx, i.e. apt points to a couple  more utils to cover some extensions. Depending on builds apt may be a separate binary, but both cover 90% of the same functionalities. Apt has some extra's, like search, show, list, and edit-sources. (which may in turn show up in your version of apt-get!)
So instead apt has some more options
apt-get is the oldest of the two notations.

[backprop]

I'm interested in "Named range" functionality, not apt-get.

[Thaddy]

Then examine my wiki entry about defensive programming?
https://wiki.freepascal.org/Defensive_programming_techniques

I still have to finish that, but the part about ranges is completed, valid and proven.

(The open rest relies more or less about changes in main/trunk)

Note "simple" code is not simple to write....

[wp]

I'm interested in "Named range" functionality

As I wrote above this functionality is available in the SVN version, not yet in CCR. Please be patient, I am a one-man-band playing at too many parties.