Re: [libreoffice-users] Split cells in Calc

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?

@Brian: 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. However ...

@Pat: Is it not possible to get the effect you need by inserting a new 
column before or after the cell that you want to split?


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