Help! Librecalc cells refuse to stay aligned

Hi,

I am using LibreCalc (the Excel version of Linux), and - despite of having aligned everything in the beginning (before I started inputting data) the way I wanted - now, when I copy-paste some data into the pre-formatted cells, some of these cells refuse to stay aligned.... or rather, their indentation refuses to be kept, otherwise they do align (to the left, right, or center, depending on how I make them align), but the indentation feels like it's getting disabled all of a sudden for those cells, and it drives me nuts, because I can't figure out where the problem is. And it happens to random cells too, not in a certain pattern so that I could (hopefully) figure out what's wrong and be able to fix it....

If any of you is using Librecalc regularly and / or has encountered this issue before - for the love of God - please share the fix with me as I can't take this anymore! Have mercy on a poor, tormented (by tables) soul

Here's the abomination (ie. the numbers 140, 210 and 590) that refuses to comply:



And there are more cells like those 3 that lose their formatting (identation), but they're lower on the page, so I couldn't include them in this screenshot, but it's the same thing with them...

Thanks in advance for any fix that you can give, I'll take anything at this point!

anybody?

now?

mrsocialselling said:

now?

Click to expand...

what now?

Does special paste (ctrl+shift+v for LibreCalc, iirc) work for you? Should help out with the formatting rules the regular copy-paste does.
Alternatively, whenever the cell losses indentation, you could clear direct formatting then re-apply the style or indentation you mean to use.

imccafey said:

you could clear direct formatting then re-apply the style or indentation you mean to use.

Click to expand...

I did it numerous times but to no avail

imccafey said:

Does special paste (ctrl+shift+v for LibreCalc, iirc) work for you?

Click to expand...

I didn't even know that this is a thing

Also, something weird is going on... well, a lot of weird stuff is going on with my PC.... well, a lot of twilight zone / Bermuda triangle-type of shit has been going on with my computers since the early 90s when I got my first PC. Whenever I go online to ask for help to something I almost always get replies like "wtf, how did you do that?", or "bro, that's not possible" LOL... Only stuff like this has been going on with my PCs for the last 30+ years

And this brings me to this point... the screenshot I've shared in the initial post of this thread had been left COMPLETELY untouched after I have uploaded it to this thread, as I was so angry and morally deflated with that crap that I didn't feel like doing anything with it anymore.

But now, after I opened it so I can try your suggestions I noticed that everything is in perfect order. Like, WTF ?!? Even I am confused (relieved though that it somehow fixed itself, because I genuinely can't find a logical reason for why it's fixed since I've not even touched it until now) and surprised although - given how much twilight zone-type of stuff I've seen on, and with my computers over the years - nothing should surprise me anymore. And yet, here we are...

But anyway, I did try the CTRL + SHIFT + V command, just out of curiosity (I genuinely have not even heard of that thing before, I'm just a casual Libre user, not a pro by any means) and it does seem to paste the info correctly into whichever cell I pasted it into. So, this might be an option for the future when paranormal fuckery happens again, so thanks for the tip

Also, I'm not really willing to bet on this, but I swear that - tomorrow after I wake up and check this file again - there's 50-50% chance that it's broken again, of its own accord and just to fuck with me again. I swear that I can totally see this happening again, I'm telling you, man, my computers never behave like everyone else's computer, it's like they have a mind and destiny of their own... and people trying to tell me how cool and advanced the AI is, their retarded AI has not seen shit of what's happening to, and with my computers on regular basis...

Hahaha, it does this to me too. I'll try the special paste thing, thanks.