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

Jomali,
I once used it to correct a goof on a cell merge operation when it was 
impractical to use undo.  I was only creating a form, so I was not 
referencing any of these cells.  The problem was that the subdivide 
required a lot of cleanup to get the cell boundaries aligned again.  
Messy, but better than starting over or using undo.
Girvin Herr


jomali wrote:
> I've been following this thread and wondering what a use case would be for
> subdividing cells.
>
>
> On Thursday, February 14, 2013, Tanstaafl wrote:
>
>   
> > 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/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/>
> > Posting guidelines + more: http://wiki.**documentfoundation.org/**
> > Netiquette <http://wiki.documentfoundation.org/Netiquette>
> > List archive: 
> > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/>
> > All messages sent to this list will be publicly archived and cannot be
> > deleted
> >
> >
> >     
>
>   

--
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