Skip Menu |
 

This queue is for tickets about the ODF-lpOD CPAN distribution.

Report information
The Basics
Id: 75358
Status: resolved
Priority: 0/
Queue: ODF-lpOD

People
Owner: Nobody in particular
Requestors: TMUELLER [...] cpan.org
Cc:
AdminCc:

Bug Information
Severity: Wishlist
Broken in: (no value)
Fixed in: 1.120



Subject: Support of Named Ranges
Download (untitled) / with headers
text/plain 936b
Hi, LibreOffice Calc has a feature, that allows to declare a name for a range. It would be great, if one could access those ranges via. The reason would be, that you don't have to use fixed cell addresses any more. Using fixed cell addresses can break easily, because cells can be selected and moved around. Ranges on the other hand, update themselves to match the position, where the cells are moved to. Another usage would be to declare special ranges for your perl module, so that you can update the information, where certain data is stored in the spreadsheet, in Calc itself. No need to edit your perl module any more. The elements tag is 'table:database-range', it has an attribute 'name' for the name of the range and an attribute 'target-range-address' containing the address of the range. The behaviour would be similar to a sheet i guess. Would it be possible to implement such a feature? Cheers, tmueller
There is a new feature in ODF::lpOD 1.120, that allows the user to get existing named ranges, or set new ones, in spreadsheets.
Hopefully it will partly or fully match your needs.

Thanks for your proposal.

On 2012-02-27 19:01:05, TMUELLER wrote:
Show quoted text
> Hi,
>
> LibreOffice Calc has a feature, that allows to declare a name for a
> range. It would be great, if one could access those ranges via.
>
> The reason would be, that you don't have to use fixed cell addresses
> any more. Using fixed cell addresses can break easily, because cells
> can be selected and moved around. Ranges on the other hand, update
> themselves to match the position, where the cells are moved to.
>
> Another usage would be to declare special ranges for your perl module,
> so that you can update the information, where certain data is stored
> in the spreadsheet, in Calc itself. No need to edit your perl module
> any more.
>
> The elements tag is 'table:database-range', it has an attribute 'name'
> for the name of the range and an attribute 'target-range-address'
> containing the address of the range.
>
> The behaviour would be similar to a sheet i guess.
>
> Would it be possible to implement such a feature?
> Cheers,
> tmueller



This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.