Named range lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- backprop · 2024-09-05 01:38 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 · 2024-09-05 08:45 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 · 2024-09-07 15:21 When is planned to be released? ---------------------------------------------------------------------- wp · 2024-09-07 15:39 When the remaining issues with the chart module are solved. ---------------------------------------------------------------------- backprop · 2024-09-07 17:21 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 · 2024-09-07 17:26 There is a write and a read sample project in folder examples/other/defined_names. ---------------------------------------------------------------------- backprop · 2024-09-07 18:17 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 · 2024-09-07 21:32 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 · 2024-09-07 23:38 Quote from: wp on September 07, 2024, 11:32:33 pmThis 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 · 2025-04-22 01:09 Quote from: wp on September 05, 2024, 10:45:58 amThis 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 · 2025-04-22 07:38 Addressing your previous question, dating back to 2024 backprop. Quote from: backprop on September 08, 2024, 01:38:06 amFunny, 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 · 2025-04-22 13:24 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 · 2025-04-22 20:16 I'm interested in "Named range" functionality, not apt-get. ---------------------------------------------------------------------- Thaddy · 2025-04-22 20:36 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 · 2025-04-22 21:01 Quote from: backprop on April 22, 2025, 10:16:00 pmI'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. ---------------------------------------------------------------------- dbannon · 2025-04-23 00:37 Quote from: Thaddy on April 22, 2025, 03:24:48 pmIt is the other way around regarding apt and apt-get but that does not matter ... No, its not the other way around.  All versions of apt automatically resolve dependencies.  Current versions of apt-get do resolve dependencies but earlier (eg < u16.04)versions did not. There are still systems in use today with that older version of apt-get.  Quote because one is an alias/symlink to the other. While possible, I have never seen it. U16.04 - U24.04, Bookworm and Trixie are different binaries.  Both call underlying libraries such as libapt*.  The advice is to not use apt in (long lived) scripts because, unlike apt-get, its syntax may change over time. But for tasks like the OP's question, "apt" is the command to use, it has a simpler syntax and better error messages. dpkg is definitely not the command to use for such tasks, it can resolve dependencies but it is laborious to do so. Davo ---------------------------------------------------------------------- backprop · 2025-04-23 09:57 Quote from: wp on April 22, 2025, 11:01:53 pmAs 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. That was almost year ago, thus I have assumed it is in OPM already, but seems it is not. I have tested SVN version back in time you wrote and it worked without problems. It is hard to track all versions and sub-versions and testing and comparing with "official" version in OPM... How long you estimate "official" version in OPM will be available with that functionality? ---------------------------------------------------------------------- Thaddy · 2025-04-23 15:22 Quote from: dbannon on April 23, 2025, 02:37:59 amQuote from: Thaddy on April 22, 2025, 03:24:48 pmIt is the other way around regarding apt and apt-get but that does not matter ... No, its not the other way around. Google it Davo. I am right. First to appear: apt-get Second to appear:apt. Apt is built on top of apt-get. ---------------------------------------------------------------------- dbannon · 2025-04-23 23:04 Quote from: Thaddy on April 23, 2025, 05:22:17 pmGoogle it Davo. I am right. First to appear: apt-get Second to appear:apt. Apt is built on top of apt-get. I am not sure just what you think is the wrong way around, my assertion was that 'apt' is the command backprop needs to use, the answer to his question is "use apt". I did not make any mention of the relative age of apt v. apt-get and suggest almost no one cares. Davo