Re: [libreoffice-users] Split cells in Calc

On Sun, 10 Aug 2014, Brian Barker wrote:

> At 11:49 10/08/2014 -0400, Robert Funnell wrote:
> > On Sun, 10 Aug 2014, Brian Barker wrote:
> > > At 13:25 10/08/2014 +0200, Pat Brown wrote:
> > > > Is there any way to split a primary (one that has not been 'merged' 
> > > > previously) cell? I can't seem to find such an option. If there is no 
> > > > current option then is it technically possible to do so?
> > >
> > > This wouldn't really make sense. One of the principal functions of a 
> > > spreadsheet is to be able to refer to individual cells in formulae. If you 
> > > split a single cell, how would you refer to each part of it separately? 
> > > What would D7 now mean? D7RB for the right, bottom sub-cell of what was 
> > > originally D7? What when you divide those cells further?
> >
> > It should in principle be possible to just renumber everything. After that, 
> > it doesn't seem to be different in principle from what happens when cells 
> > are merged.
>
> That sounds impressive, but it's just magic! If you explained what you meant, 
> you might see why it makes little sense.
>
> If you divide D7 horizontally, do the two parts become D7 and E7? In that 
> case, do columns E onward get relabelled to F and so on? And formulae 
> adjusted? Since column E now has only one cell, what does a reference to E6 
> mean? Is the column now labelled D or E or D/E?
>
> If you now happen to divide F9, does it become F9 and G9 or does it take 
> advantage of the ghost of column E and label itself E9 and F9? Are the 
> columns now labelled D/E and E/F?

As also mentioned by another poster, if you want to effectively split 
a single cell, you can add a row or column and then merge cells that 
you don't want to be split. (Perhaps a macro could be developed to do 
this.) Would your concerns not then be resolved?

--
To unsubscribe e-mail to: users+unsubscribe@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