Re: [libreoffice-users] calc: method to subdivide individual cells

On 2013-02-14 9:19 AM, Brian Barker <b.m.barker@btinternet.com> wrote:
> At 08:50 14/02/2013 -0500, Nobody Noname wrote:
> > ... but it is much more complicated than if there was the possibility
> > to just subdivide a single cell into multiples...

> OK: suppose you divide cell Xn into four cells- two vertically and two
> horizontally.  How do you now refer to the four new cells in formulae?

Initially, until some method was developed that made sense, it could 
just be a limitation of split cells that you can't use them in formulas.

And maybe it would have to stay that way. None of the times I wanted to 
be able to do this was it critical that I me able to use them in formulas.

> And which of the now four separate values gets used if you refer to
> plain cell Xn in a formula?

Pick one (upper left, lower right, etc). Could even be a pref. Or, as 
above, make it unsupported, unless/until a method is developed for 
supporting it that makes sense.

--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted