2014 Archives by date, by thread · List index

# Re: [libreoffice-users] Split cells in Calc

```At 12:41 10/08/2014 -0400, Robert Funnell wrote:
```
```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?
```
```
There are no concerns to be resolved: that quite different technique is the right way to do this!
```
```
Brian Barker
```
--
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
```