Pasting data from Calc into an online forum ruins the formatting - What can I do?

English
#1

Hi, I’ve got the following problem: I have some data in LibreOffice Calc (rows and columns) that i want to copypaste into a forum. I used to this before and it worked without issue, although at the time I used Openoffice. So what happens now, when I copyandpaste the data into a forum is that the data is all jumbled up, there’s [td]-tags and it’s all super stretched out so I need to scroll like 10 seconds to reach the end of the site. What am I doing wrong and how can I fix this? I just want to copypaste my data like before.

Edit: Here’s a screenshot showing the issue:

959×4100 556 KB

PS: As I found out, when i copypaste the data from libreoffice to openoffice, it pastes it as an image that I can change in size and all. super weird, its no longer in typical Calc-cells but one image object.

#2
Date Category Person Value
2016-03-06 So Category 5 Gary -196,37
2016-06-03 Fr Category 1 Ian 888
2016-01-25 Mo Category 2 Bob 86,93
2016-02-08 Mo Category 3 Ian -419,7
2016-01-15 Fr Category 1 Gary 73,12
2015-12-27 So Category 4 Bill 98,95
2016-01-25 Mo Category 4 Ian 369,31
2016-01-30 Sa Category 3 Gary 460,52
2016-01-15 Fr Category 5 Ian 9,58
2016-01-06 Mi Category 4 Fred -149,04
#3

I’m sorry, I don’t understand the meaning of this posting.

#4

I copied a cell range into this forum, and the result looks just fine.

#5
1080 Snowboarding WW LTD Japan LTD Release
1080 Snowboarding 2,03 0,02 1998
1080 Avalanche 0,02 2004
Animal Crossing WW LTD Japan LTD Release
New Horizons 45,85 11,31 2020
New Leaf 13,05 5,95 2012
Wild World 11,75 5,35 2005
Let’s Go to the City 4,32 1,39 2008
Happy Home Designer 3,51 1,6 2015
Animal Crossing 2,27 0,64 2001
Animal Crossing e+ 0 0,39 2003
Animal Forest 0 0,21 2001
ARMS WW LTD Japan LTD Release
ARMS 2,72 0,47 2017
Banjo & Kazooie WW LTD Japan LTD Release
Banjo-Kazooie 3,65 0,41 1998
Banjo-Tooie 1,49 0,19 2000
Brain Training WW LTD Japan LTD Release
Brain Age/Dr. Kawashima 19,01 3,96 2005
Brain Age 2/Dr. Kawashima 14,88 5,1 2005
Big Brain Academy 6,15 1,64 2005
Big Brain Academy: Wii Degree 3,34 0,38 2007
Big Brain Academy: Brain vs. Brain 1,94 0,45 2021
Brain Age/Dr. Kawashima NSW 1,27 0,42 2019
Brain Age: Concentration Training 0,27 2012
Diddy Kong Racing WW LTD Japan LTD Release
Diddy Kong Racing 4,88 0,65 1997
Diddy Kong Racing DS 1,59 0 2007
Donkey Kong WW LTD Japan LTD Release
Donkey Kong Country 9,3 3 1994
Donkey Kong Country Returns 6,53 1 2010
Donkey Kong 64 5,27 1,1 1999
DK2: Diddy’s Kong Quest 5,15 2,21 1995
Tropical Freeze NSW 4,62 0,29 2018
Donkey Kong Land 3,91 1,08 1995
DK3: Dixie Kong’s Double Trouble 3,51 1,77 1996
Donkey Kong Country Returns 3D 2,94 0,37 2013
Donkey Kong Land 2 2,35 0,06 1996
Tropical Freeze WIU 2,02 0,19 2014
Donkey Kong Land 3 1,03 0,21 2000
Dr. Mario WW LTD Japan LTD Release
Dr. Mario GB 5,34 2,08 1990
Dr. Mario NES 4,85 1,53 1990
Dr. Mario & Puzzle League 0,12 2005
Famicom Mini: Dr. Mario 0,13 2004
Dr. Mario 64 2001
Earthbound WW LTD Japan LTD Release
Earthbound 0,62 1994
Earthbound Beginnings 0,4 1989
Mother 1+2 0,39 2003
Mother 3 0,37 2006
Endless Ocean WW LTD Japan LTD Release
Endless Ocean 0,05 2007
Endless Ocean 2: Blue World 0,04 2009
Excite WW LTD Japan LTD Release
Excitebike 4,16 1,57 1984
Excitebike GBA 0,11 2004
Excitebike 64 0,11 2000
Excite Truck 0,08 2007
ExciteBots 2009
Fire Emblem WW LTD Japan LTD Release
Three Houses 4,12 0,58 2019
Birthright+Conquest 3,09 0,78 2015
Awakening 2,37 0,48 2012
Engage 1,68 0,45 2023
Echoes: Shadows of Valentia 1 0,2 2017
Path of Radiance 0,16 2005
Radiant Dawn 0,17 2007
Mystery of the Emblem 0,78 0,78 1994
Holy War Story 0,5 0,5 1996
The Sealed Sword 0,35 0,35 2002
Shadow Dragon and the Blade of Light 0,33 0,33 1990
Gaiden 0,32 0,32 1992
Hero of Light and Shadow 0,25 0,25 2010
Blazing Sword 0,27 2003
Thracia 776 0,11 0,11 1999
Shadow Dragon 0,25 2008
Sacred Stones 0,25 2004
Fitness WW LTD Japan LTD Release
Wii Fit 22,67 3,6 2007
Wii Fit Plus 21,13 2,51 2009
Ring Fit Adventure 15,38 4,09 2019
Flash Focus/Eye Training 3,23 0,95 2007
Wii Fit U 0,13 2014
F-Zero WW LTD Japan LTD Release
F-Zero SNES 2,85 0,9 1990
F-Zero X 1,1 0,1 1998
F-Zero GX 0,1 2003
F-Zero Maximum Velocity 1,05 0,33 2001
F-Zero Falcon Legend 0,01 2003
F-Zero Climax 0,01 0,01 2004
Golden Sun WW LTD Japan LTD Release
Golden Sun 1 1,65 0,36 2001
Golden Sun: The Lost Age 1,12 0,25 2002
Golden Sun: Dark Dawn 0,08 2010
Ken Griffey Jr Baseball WW LTD Japan LTD Release
Ken Griffey Jr. Presents Major League Baseball 1994
Ken Griffey Jr.'s Winning Run 1996
Major League Baseball Featuring Ken Griffey Jr. 1998
Killer Instinct WW LTD Japan LTD Release
Killer Instinct 3,2 0 1994
Killer Instinct GB 0 1995
Killer Instinct Gold 0 1996
Kirby WW LTD Japan LTD Release
Kirby and the Forgotten Land 6,96 1,84 2022
Dreamland 5,13 1,72 1992
Star Allies 4,38 1,31 2018
Super Star Ultra 2,99 1,27 2008
Triple Deluxe 2,66 0,8 2014
Dreamland 2 2,36 1,51 1995
Squeak Squad 2,27 1,18 2006
Nightmare in Dreamland 2,1 0,83 2002
Return to Dreamland 1,93 0,67 2011
Epic Yarn 1,85 0,49 2010
Return to Dreamland Deluxe 1,82 0,54 2023
Kirby 64: The Crystal Shards 1,77 1,07 2000
Kirby’s Adventure NES 1,75 1 1993
Planet Robobot 1,64 0,59 2016
Kirby and the Amazing Mirror 1,47 0,7 2004
Superstar 1,44 1,1 1996
Mass Attack 1,22 0,41 2011
Dreamland 3 0,08 1988
Labo WW LTD Japan LTD Release
Toy-Con 01: Variety Kit 1,42 0,33 2018
Toy-Con 04: VR Kit 0,08 2019
Toy-Con 02: Robot Kit 0,06 2018
Toy-Con 03: Drive Kit 0,06 2018
Lightgun-titles WW LTD Japan LTD Release
Duck Hunt 28,31 1984
Hogan’s Alley 1,27 1984
Yoshi’s Safari 0,01 1993
Barker Bill’s Trick Shooting 0 1990
Gumshoe 0 1986
To The Earth 0 1990
Wild Gunman 1984
Luigi’s Mansion WW LTD Japan LTD Release
Luigi’s Mansion 3 13,98 1,46 2019
Dark Moon 6,48 1,31 2013
Luigi’s Mansion GCN 3,33 0,35 2001
Luigi’s Mansion 2 HD 1,19 0,16 2024
Luigi’s Mansion 3DS 0,1 2018
Mario and Luigi RPGs WW LTD Japan LTD Release
Bowser’s Inside Story 4,56 0,77 2009
Dream Team 2,7 0,47 2013
Superstar Saga 2,15 0,44 2003
Partners in Time 1,73 0,42 2005
Paper Jam 1,08 0,26 2015
Superstar Saga+Bowser’s Minion 0,07 2017
Bowser’s Insider Story+Bowser Jr.'s Journey 0,03 2018
Mario Football WW LTD Japan LTD Release
Mario Strikers: Charged 2,6 0,23 2007
Mario Strikers: Battle League 2,63 0,17 2022
Mario Strikers 1,6 0,19 2006
Mario Golf WW LTD Japan LTD Release
Mario Golf: Super Rush 2,48 0,31 2021
Golf 2,12 1990
Mario Golf 64 1,47 0,47 1999
Mario Golf: Toadstool Tour 1,27 0,19 2003
Mario Golf: Advance Tour 0,89 2004
Mario Golf GB 0,22 1999
Mario Golf: World Tour 0,13 2014
#6

Yes, here it seems to work. But not in the forum I usually post this data (XenForo software). Also as you can see in the image I linked in the opening post, when I copypaste data to OpenOffice, it turns into an image object. :confused:

#7

Welcome!

Yes, you are right, OpenOffice does not paste the clipboard as we would like. Let’s try to figure out the reasons.

Try copying part of the table from LibreOffice Calc, switch to OpenOffice Calc and use not the usual Paste, but the Special Paste (Ctrl+Shift+V)

The form for selecting the appropriate insert format contains a list of all the options that OpenOffice can offer. More on that later, but now let’s look at this line, which the red arrow points to.

image

This is the reason: OpenOffice was born much earlier than the modern version of LibreOffice. It’s like Scarlett O’Hara saw a washing machine or King Arthur saw Tesla.

Now about why OpenOffice accepts tabular data as an image. See how graphic formats are the first in the list of possible options? These are the ones that OpenOffice tries to use when it tries to execute your “Paste it here” command.

What to do in this case? The answer is to experiment. In addition to graphic options, the list also includes HTML, RTF, and Unformatted text. Try each of them and perhaps you will find the insertion option that best suits your needs.

Alternatively, do not transfer data from LibreOffice to OpenOffice. Open the source file you are going to copy from and the destination file in the same program - either OpenOffice Calc or LibreOffice Calc - but not in different ones.

1 Like
#8

This shows your copied source was pasted as html, where a cell wold be enclosed in td /td and I guess some precaution against hacking/disturbing the site converted the usual <td> in a [td], so your table is now mostly harmless, but not formatted.
.
Check the rules of the site where you paste. Maybe there is a way. Maybe you could upload a pdf there. There is no worldwide set of rules for this and sites are always changing.

#9

I see the same in parallel install, when I try to copy from versions 7.x to 6.x I see it as a reminder to open the file via File>Open instead of double-click in file-explorer.

#10

Ok, and is there no way to turn it into instead of [td]?

i just tried to copyandpaste the jumbled up code into Windows editor to replace all [td]-tags with , but when I copypaste into Editor, there are no tags at all and the whole data is just displayed correctly (without the individual cells though).

I can’t even edit the forum post anymore, because my PC almost freezes trying to do so, have to close Chrome via task manager “end task” :confused:

#11

Thx so far. But can you also help me what I need to do to paste the data correctly into the forum? As you can see in the screenshot, it all turns into a lot of [td]-tags.

I tried copying from LibreOffice, special pasting it into Openoffice and choosing different option from the “Selection” that can be seen in your image, but when I paste it into the forum, it always turns into jumbled up [td]-stuff. I just want it to be properly displayed. And it can’t be the forum software’s fault really, because all my old tables with older data are being displayed correctly. Only now since I started using LibreOffice, it doesnt work anymore. :confused:
I really feel like crying rn because I don’t know what to do anymore, sorry.

#12

Two errors in your thoughts:

  • You assume forum software never changes
  • You assume LibreOffice is “doing” something wrong, only because of timing. But as it works for this site, you have to find out where the different behaviour originates.

As you now stated it worked before using LibreOffice, meybe tell what you used before…
.

Clipboards are complicated. The receiving program tells, what it understands. The Clipboard will then deliver this. This means: The editor does ask for text-only and gets text-only, without any tags.

#13

I used OpenOffice before. No problem ever.

I asked the forum admins if the software changed, gonna wait for their reply, but i doubt there are any significant changes.

If the forum is not the problem, what else can I do then? I simply want to copypaste the above table into the forum. :confused:

#14

Note that your forum software shows the content correctly in the editing box, until you publish it. Yes, it is certain that LibreOffice tables do contain something that was missing in OOo tables; but that doesn’t mean it’s LibreOffice fault - we improve the fidelity of e.g. HTML content that we send to clipboard, to help those applications that can handle that data; and if some application can’t process some HTML, but still tries to use HTML, it’s that app’s (in this case: forum software) fault.

#15

Ok, but I won’t be able to change the forum that I’m only a user of.

So what can I do about my LibreOffice-data to correctly paste it into the forum?

I mean, I changed from OpenOffice to LibreOffice, because people told me Openoffice is dead. If LibreOffice has some unique copypasting-properties, though, I guess I need to go back to OpenOffice? That’d be a lot of work to recompile all my sales data again, ugh. Surely there must be a solution within LibreOffice?

#16

You always can file bug reports.

Or use OpenOffice - that’s always an option. Choosing another software just because someone told you something (not because of actual problems that you face) is not always reasonable.

#17

So there’s absolutely no way to properly copypaste with LibreOffice? :frowning:

I doubt my problem would be accepted as a bug report, millions of other users would have experienced the same issue before me.

#18

There is no problem copypasting within LibreOffice - it does that properly already. The problem is outside.

Lol. This means, no one should file bugs? Well, it’s your call. Note that (1) those millions before you must use that forum software (is it so popular? No such problems heard here before - would all those millions keep silent?); (2) they must use LibreOffice; and (3) they must paste tables from it to the forum. Is that so common? I doubt it.

#19

I’m sorry, I’m crying here right now. I just don’t know what to do and I need a step-by-step solution. It was so much work to compile all the data and now it all goes to ruin only because I cannot copypaste it. This isn’t some special forum, it’s a bog standard forum like they exist in the millions, so what can be the problem …

#20
  1. Open your OpenOffice.
  2. Use it.

Note that you can even have both OpenOffice and LibreOffice side-by-side.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.