View original (French)

Split cells in OpenOffice

Solved
Chachou -  
 sc -
Hello,
I can't seem to split the cells in OpenOffice Calc, can you please tell me how to do it? Thank you! It's driving me crazy.
Configuration: Windows XP Internet Explorer 6.0

11 réponses

Réponse 1 / 11
Duoner
 
Hello,

To split the contents of a cell into two or more cells, the data in the original cell must have the same separator (a period, a space, etc.).
You also need to create space to accommodate the data; simply insert a column next to the original column.
Select the desired cell, then go to the "Data"/Text to Columns menu...
You need to specify the separator, and the formatting will be applied automatically.
P.S. A visual is in the "Text to Columns..." dialog box.

I hope this is the response you were looking for.

Best regards.
16
Gregz
 
Hello,
Actually, you just need to select THE (one) cell that was previously merged and do "FORMAT" >> "Merge Cells"
Normally, this action will unmerge them.
0
Raymond PENTIER Posted messages 58545 Registration date   Status Contributeur Last intervention   17 474 > Gregz
 
... as antifutur said in April ...
https://forums.commentcamarche.net/forum/affich-11218348-fractionner-des-cellules-sur-openoffice#20
0
sc
 
Thank you very much for the reply, it saved me 3 hours of searching!
0
Réponse 2 / 11
freaks
 
split an origin cell
I'm looking for....
8
Chachou
 
Thank you, that's nice :)
0
Réponse 3 / 11
Perrine
 
In my opinion, the only solution is to create a new row (insert row) under the row of the cell you're interested in, and to merge (vertically) all the cells of these two rows (the row of your cell and the new row), except for your cell (the one you want to be split in two). I just hope your table isn't too big.
7
Raymond PENTIER Posted messages 58545 Registration date   Status Contributeur Last intervention   17 474
 
... or the same thing with columns ...
1
Réponse 4 / 11
DrShiva
 
Hi,

It's possible in OpenOffice, you just need to select the cell and go to format/cell/border and choose the desired diagonal (left to right or right to left) and then select the thickness of the line...
there you go, the cell is "divided" diagonally in two!

However, I'm not sure how to write text in each of the diagonal parts of the divided cell (I've done it before)...

Good luck!
6
Your Mother
 
Yeah! It works!! However, to write in each section, I had to put in long pieces of space... But good result anyway!
Thanks!
0
Réponse 5 / 11
antifutur
 
Even easier, found more or less by chance after going through this topic, click on the Merge Cells button, which also serves to split them again!
2
chabzn
 
Yes, but that only works in the case where two cells have been merged in the first place...
1
Réponse 6 / 11
freaks
 
Hello Chachou
I suppose you merged some cells and now you want to split them again. Just press delete (Delete key on the keyboard) and check only "format"

P.S.: If you found the solution to your problem, please remember to mark your message as resolved.
0
Chachou
 
No, that's not it. I want the cell to be split in two, but I can't find how to do it. It seems like the function doesn't exist on Open Office. Do you see what I mean?
0
Réponse 7 / 11
transat Posted messages 31956 Registration date   Status Contributeur Last intervention   9 021
 
Hello
We can split the cells of a table in writer but it seems to me that it is impossible in calc (subject to confirmation)
For freaks. I highly doubt that the open office forum will indicate how to split a cell in Excel
@+
--

Curiosity on CCM is not a flaw but a quality
0
freaks
 
good evening transat
the link was for the example (similarity of the programs), I came to the same conclusion as you :)
0
transat Posted messages 31956 Registration date   Status Contributeur Last intervention   9 021 > freaks
 
Well received
Have a good evening
--

Curiosity about CCM is not a flaw but a quality
0
Réponse 8 / 11
generation60
 
the 2 diagonals appear
impossible to select just one
0
Réponse 9 / 11
freaks
 
Uh... I can't find it :( and for what
ask the question on the Open Office forum

http://www.commentcamarche.net/forum/affich 9215701 split a cell in Excel
-1
Réponse 10 / 11
Greg
 
Hello,
You select the cell in question. Then Format. Next you have Merge Cells checked. You uncheck it. And that's it!
-2
Raymond PENTIER Posted messages 58545 Registration date   Status Contributeur Last intervention   17 474
 
Greg, have you really thought about what you've written?
And have you tested your manipulation?
0
Réponse 11 / 11
artec
 
Select the cell and click on delete.
Only select the format and, normally, it removes the merge.
In any case, it works on my version.
-2