Bug #75358 for ODF-lpOD: Support of Named Ranges

Mon Feb 27 19:01:05 2012 TMUELLER [...] cpan.org - Ticket created

Subject:

Support of Named Ranges

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

Wed Mar 28 18:11:52 2012 jmgdoc [...] cpan.org - Correspondence added

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

Wed Mar 28 18:11:53 2012 The RT System itself - Status changed from 'new' to 'open'

Thu Mar 29 18:34:52 2012 jmgdoc [...] cpan.org - Status changed from 'open' to 'resolved'

Thu Mar 29 18:34:53 2012 jmgdoc [...] cpan.org - Fixed in 1.120 added