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 column that has this header) you can reference the
whole input area within calc...
Example: Add eg. the sting "banana" as a column header somewhere within
a sheet and add some numerical data downside of it then at a place
somewhere else within the sheet you can use it like =sum(banana)
Differently to Excel you can add data whereelse you want within that
range (at the beginning, within that range (adding rows within that
area) and adding columns at the end of that range)
just my 2 cents....
Kind regards, Joost
Am 14.12.2015 um 04:23 schrieb #PATHANGI JANARDHANAN JATINSHRAVAN#:
Hi Dennis,
I have filed one here:
https://bz.apache.org/ooo/show_bug.cgi?id=126734 with the patch available in
that issue
Thanks
Jatin
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@openoffice.apache.org
For additional commands, e-mail: dev-h...@openoffice.apache.org
