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:
3/5/2014
It needs to be outputted at the other table as:
03/05/14
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.
EDIT:
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.
EDIT AGAIN:
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.