Ask Your Question

Format not changing for date - help! [closed]

asked 2014-03-17 16:46:10 +0100

Bryan Neff gravatar image

updated 2014-03-17 17:14:52 +0100

Hey, so I have two tables - one for raw data, and another that references the raw data. The problem I'm having is with the date of the Raw Data

It goes into the table like this:


It needs to be outputted at the other table as:


There's a couple problems. First of all, whenever I change the format of the column on either table, it just does nothing. It's like it ignores any changes to formatting I make. Oddly, if I put in a user-defined format, it still does nothing, but it seems to mix everything up. If I put in YY/MM/DD, it says the output will be 03/05/18... which is weird, right? Of course, it still actually does nothing on the table itself - since changing the format in any way seems to do absolutely nothing, and I don't know why.


After I play with it a bit, it sticks ' before the dates. If I erase that ', it suddenly formats it... but I don't know why it's just not formatting it correctly when I insert the data. It's weird.


Yeah, it definitely seems like LibreOffice decides to ignore applying formatting when pasting, which is mildly annoying. When the text is pasted, it needs to be formatted to the column's style..

It may normally do that, but the page is set, for better or worse, to grey out via page break anything that doesn't have data. I don't know how to undo this option - I really wish I did.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 08:20:58.786165

1 Answer

Sort by » oldest newest most voted

answered 2014-03-17 23:45:28 +0100

m.a.riosv gravatar image

Seems as you have dates as text, to convert in true dates values when pasting, click on the arrow in the paste icon, and select unformatted text, then you can select the type data for every column, clicking on the column header and select the type in drop down box.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-03-17 16:46:10 +0100

Seen: 239 times

Last updated: Mar 17 '14