Thanks Alan. I need to split a single cell and work with it as two cells
(i.e. text as well as background and cell borders). Maybe the only way to
do this is to merge two columns and then split the one cell that I need to
work with. This is rather ham-fisted but may be the only solution.
On 10 August 2014 13:52, Alan B <firstname.lastname@example.org> wrote:
On Sun, Aug 10, 2014 at 7:25 AM, Pat Brown <email@example.com> 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?
Presuming cell content is text, the "Data | Text to Columns" operation can
split the text into multiple cells.
For splitting a single cell it may be simplest to use the "Fixed width"
separator option and then mark where to split the cell content.
If there is a column of cells that needs to be split into multiple cells
then either "Fixed width" or "Separated by" depending on cell content would
be the technique to use.
To split up a column of cells as a group each cell in the column would
need similar characteristics re: where the split should be done. e.g. each
cell contains words separated by commas then could use the "Separated by"
option, tick "Comma" and the contents of each cell would be split across
multiple cells at the comma separator.
Hope the above is the kind of solution you're looking for.
To unsubscribe e-mail to: firstname.lastname@example.org
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
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy