Ask Your Question
1

Divide cell (libreoffice 4.3.7.2) on Mac [closed]

asked 2017-01-02 12:05:06 +0200

appreciatethehelp gravatar image

updated 2017-05-10 05:51:16 +0200

Hey guys am new here.

I just want to know how to divide a cell into pieces in calc.

I want to take one column in a piece I am working on and divide it into 3 equal parts all the way down.

To help clarify the question I have attached an example document.

Also, you will notice that the document has been "split" just after the "F" column. I did this by accident and would like to undo it- how can I do this? Hitting the "undo" button simply undid every other thing I did BUT the split…

Command Z (which is usually undo on mac) didn't help either…

Thanks in advance!

C:\fakepath\Screen Shot 2017-01-02 at 11.56.19 PM.png

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-05-11 21:28:01.649910

Comments

Gave you some karma. Of course, you can upload a picture somewhere else and post a link here.

floris v gravatar imagefloris v ( 2017-01-02 12:07:25 +0200 )edit

Thanks very much!

I uploaded the screenshot before editing it by accident- whoops!

How do I edit my question? I can't find the "edit" option haha. My, this is going well, isn't it!?

appreciatethehelp gravatar imageappreciatethehelp ( 2017-01-02 12:23:40 +0200 )edit

I have figured out how to edit my question (an edit button would've been more obvious than going through the "updated" part but hey.)

The attached screenshot of the problem is now relevant/more clear.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-01-02 12:35:28 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2017-01-02 12:24:25 +0200

updated 2017-01-02 14:26:50 +0200

Edit: C:\fakepath\Test 1.ods

Ciao, someone gave you 10 points and you can attach a screenshot now.

Edit: now I see who was. Edit: your screenshot does not help to understand the problem.

Have you a backup of your file? Have you set the backup options of Libre Office? Have you set Time Machine backup in your Mac? So you can restore your original file ...

But I don't thik it is possible split a cell …

If my answer helped you, vote it with ✔ and with ∧ (here on the left)

edit flag offensive delete link more

Comments

Thanks for the answer!

I have figured out how to edit my question (an edit button would've been more obvious than going through the "updated" part but hey.)

Sorry about the screenshot- I uploaded the wrong one by mistake.

The attached screenshot of the problem is now relevant/more clear.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-01-02 12:36:38 +0200 )edit

Also I don't have a backup of the file. That's OK as I had only just started it, but I can't think of a good reason why I wouldn't be able to undo that split.

So if I split a document by accident, I have to load an older version of the file to correct it?

That would mean saving documents constantly just in case I end up splitting the document, not being able to undo the split and having to reload an older version!

appreciatethehelp gravatar imageappreciatethehelp ( 2017-01-02 12:40:15 +0200 )edit

You can merge 3 cells for write the heading and 3 single coloumn for write dd, mm , yyyy. Look at my attached file please in editated first answer.

charlie.it gravatar imagecharlie.it ( 2017-01-02 14:20:17 +0200 )edit

That solves the issue. Thanks Charlie!

So no way to undo the split thing huh? Dang. Will have to save often!

appreciatethehelp gravatar imageappreciatethehelp ( 2017-01-02 15:50:46 +0200 )edit
0

answered 2017-05-10 12:20:33 +0200

Lupp gravatar image

updated 2017-05-10 12:21:49 +0200

You cannot divide (split) individual cells in spreadsheets. See also my answer to a similar question here.
If you created an overlapping area with the 'Merge' tool you can revert this using a menu item named 'Split', but that's just a misleading name. The individual cells never ceased to exist.

A relevant difference between this question and the one linked in above is that you also want to know how to "split all the way down".
Functionally this can be done by inserting two columns to the right of the one in question. Everything else will be moved to the right then, and references will automatically adapt to changed column labels where needed. This can be reverted by 'Delete' selected columns.
(Insertion of columns will fail if the rightmost column(AMJ) has any content.)

edit flag offensive delete link more

Comments

My apologies Lupp; this is a very old thread that should be closed.

appreciatethehelp gravatar imageappreciatethehelp ( 2017-05-11 21:27:11 +0200 )edit

The thread is just over months old. Do you think contrubutors here should write their answers every 4 months anew? My answer is valid now and was valid 30 years ago.
You may close this thread, of course. (What good for?)
I posted this answer because the one above is misleading (and probably not an answer at all). Only the last comment by charlie.it does actually hit the topic.

Lupp gravatar imageLupp ( 2017-05-11 22:39:03 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2017-01-02 12:05:06 +0200

Seen: 147 times

Last updated: May 10 '17