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 answers

  1. 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
    2. sc
       
      Thank you very much for the reply, it saved me 3 hours of searching!
      0
  2. freaks
     
    split an origin cell
    I'm looking for....
    8
    1. Chachou
       
      Thank you, that's nice :)
      0
  3. 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
    1. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
       
      ... or the same thing with columns ...
      1
  4. 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
    1. 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
  6. 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
    1. chabzn
       
      Yes, but that only works in the case where two cells have been merged in the first place...
      1
  7. 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
    1. 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
  8. transat Posted messages 31956 Registration date   Status Contributor 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
    1. freaks
       
      good evening transat
      the link was for the example (similarity of the programs), I came to the same conclusion as you :)
      0
      1. transat Posted messages 31956 Registration date   Status Contributor Last intervention   9 021 > freaks
         
        Well received
        Have a good evening
        --

        Curiosity about CCM is not a flaw but a quality
        0
  9. generation60
     
    the 2 diagonals appear
    impossible to select just one
    0
  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
    1. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
       
      Greg, have you really thought about what you've written?
      And have you tested your manipulation?
      0
  12. 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