Re: Calc Selections of Entire Rows and Columns

2015-12-16 Thread #PATHANGI JANARDHANAN JATINSHRAVAN#
>> From: #PATHANGI JANARDHANAN JATINSHRAVAN# >> [mailto:jatinshr...@e.ntu.edu.sg] >> Sent: Tuesday, December 15, 2015 03:23 >> To: dev@openoffice.apache.org >> Subject: Re: Calc Selections of Entire Rows and Columns >> >> Hi Andre, >> Yes, I can take a look at

RE: Calc Selections of Entire Rows and Columns

2015-12-15 Thread Dennis E. Hamilton
:jatinshr...@e.ntu.edu.sg] > Sent: Tuesday, December 15, 2015 03:23 > To: dev@openoffice.apache.org > Subject: Re: Calc Selections of Entire Rows and Columns > > Hi Andre, > Yes, I can take a look at implementing that, but can we make that a > separate issue and file anot

Re: Calc Selections of Entire Rows and Columns

2015-12-15 Thread #PATHANGI JANARDHANAN JATINSHRAVAN#
Hi Andre, Yes, I can take a look at implementing that, but can we make that a separate issue and file another ticket for that with a new patch? That would probably be better suited for a different patch to this one. That’s what I feel. Thanks Jatin On 12/15/15, 4:10 AM, "Joost

Re: Calc Selections of Entire Rows and Columns

2015-12-14 Thread Joost Andrae
Hi Jatin, it would be great to have that functionality in Calc but did you consider to support this within the Excel import filter as it is an Excel functionality ? Alternatively a user can use this: When using the magic type range names (adding a column header you can parse over the whole c

Re: Calc Selections of Entire Rows and Columns

2015-12-13 Thread #PATHANGI JANARDHANAN JATINSHRAVAN#
: #PATHANGI JANARDHANAN JATINSHRAVAN# Subject: RE: Calc Selections of Entire Rows and Columns Is there a Bugzilla issue with Jatin's patch? > -Original Message- > From: Damjan Jovanovic [mailto:dam...@apache.org] > Sent: Sunday, December 13, 2015 08:57 > To: Dennis Hamilton

RE: Calc Selections of Entire Rows and Columns

2015-12-13 Thread Dennis E. Hamilton
Is there a Bugzilla issue with Jatin's patch? > -Original Message- > From: Damjan Jovanovic [mailto:dam...@apache.org] > Sent: Sunday, December 13, 2015 08:57 > To: Dennis Hamilton > Cc: Apache OO ; #PATHANGI JANARDHANAN > JATINSHRAVAN# > Subject: Re: Calc Sel

RE: Calc Selections of Entire Rows and Columns

2015-12-13 Thread Dennis E. Hamilton
; From: Dennis E. Hamilton [mailto:orc...@apache.org] > Sent: Sunday, December 13, 2015 13:54 > To: dev@openoffice.apache.org > Subject: RE: Calc Selections of Entire Rows and Columns > > > -Original Message- > > From: Andreas Säger [mailto:saege...@t-online.de] > >

RE: Calc Selections of Entire Rows and Columns

2015-12-13 Thread Dennis E. Hamilton
. - Dennis > -Original Message- > From: Damjan Jovanovic [mailto:dam...@apache.org] > Sent: Sunday, December 13, 2015 08:57 > To: Dennis Hamilton > Cc: Apache OO ; #PATHANGI JANARDHANAN > JATINSHRAVAN# > Subject: Re: Calc Selections of Entire Rows and Columns > > O

RE: Calc Selections of Entire Rows and Columns

2015-12-13 Thread Dennis E. Hamilton
> -Original Message- > From: Andreas Säger [mailto:saege...@t-online.de] > Sent: Sunday, December 13, 2015 13:15 > To: dev@openoffice.apache.org > Subject: Re: Calc Selections of Entire Rows and Columns > > Am 13.12.2015 um 17:12 schrieb Dennis E. Hamilton: > >

Re: Calc Selections of Entire Rows and Columns

2015-12-13 Thread Andreas Säger
Am 13.12.2015 um 17:12 schrieb Dennis E. Hamilton: > The TL;DR: For full row and column selections in formulas, the trick is to > arrange to accept something like A:A and to recognize the explicit OO.o idiom > (i.e., A$1:A$1048576) and show it as A:A. The trick is to always write, in > the Open

Re: Calc Selections of Entire Rows and Columns

2015-12-13 Thread Damjan Jovanovic
gt; > Damjan > > -Original Message- > > From: Dennis E. Hamilton [mailto:orc...@apache.org] > > Sent: Saturday, December 12, 2015 19:50 > > To: dev@openoffice.apache.org > > Cc: dam...@apache.org; '#PATHANGI JANARDHANAN JATINSHRAVAN#' > >

RE: Calc Selections of Entire Rows and Columns

2015-12-13 Thread Dennis E. Hamilton
roperability). - Dennis > -Original Message- > From: Dennis E. Hamilton [mailto:orc...@apache.org] > Sent: Saturday, December 12, 2015 19:50 > To: dev@openoffice.apache.org > Cc: dam...@apache.org; '#PATHANGI JANARDHANAN JATINSHRAVAN#' > > Subject: Calc Selection

Calc Selections of Entire Rows and Columns

2015-12-12 Thread Dennis E. Hamilton
The specification of entire rows and columns in cell range addresses is covered in the ODF 1.2 specification. Part 1 provides some detail in section 9.2.4 Column and Row Range Addresses. The OpenFormula specification (ODF 1.2 Part 2) provides syntax for it in section 5.8 References. This is w