Recent

Author Topic: Named range  (Read 692 times)

backprop

  • Full Member
  • ***
  • Posts: 101
Named range
« on: September 05, 2024, 03:38:06 am »
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

  • Hero Member
  • *****
  • Posts: 12459
Re: Named range
« Reply #1 on: September 05, 2024, 10:45:58 am »
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

  • Full Member
  • ***
  • Posts: 101
Re: Named range
« Reply #2 on: September 07, 2024, 05:21:18 pm »
When is planned to be released?

wp

  • Hero Member
  • *****
  • Posts: 12459
Re: Named range
« Reply #3 on: September 07, 2024, 05:39:50 pm »
When the remaining issues with the chart module are solved.

backprop

  • Full Member
  • ***
  • Posts: 101
Re: Named range
« Reply #4 on: September 07, 2024, 07:21:42 pm »
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.
« Last Edit: September 07, 2024, 07:27:57 pm by backprop »

wp

  • Hero Member
  • *****
  • Posts: 12459
Re: Named range
« Reply #5 on: September 07, 2024, 07:26:34 pm »
There is a write and a read sample project in folder examples/other/defined_names.

backprop

  • Full Member
  • ***
  • Posts: 101
Re: Named range
« Reply #6 on: September 07, 2024, 08:17:58 pm »
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.

« Last Edit: September 07, 2024, 09:07:10 pm by backprop »

wp

  • Hero Member
  • *****
  • Posts: 12459
Re: Named range
« Reply #7 on: September 07, 2024, 11:32:33 pm »
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

  • Full Member
  • ***
  • Posts: 101
Re: Named range
« Reply #8 on: September 08, 2024, 01:38:06 am »
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.

« Last Edit: September 08, 2024, 01:53:17 am by backprop »

 

TinyPortal © 2005-2018