Ask Your Question

Pasting from website in calc looses data [closed]

asked 2015-01-16 21:34:17 +0100

juanc gravatar image

updated 2020-08-11 17:41:54 +0100

Alex Kemp gravatar image

I want to copy a html table that contains number like this:


when I paste into LibreOffice Calc I get this number,


I want to obtain the full text.

Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-11 17:42:07.936299

1 Answer

Sort by » oldest newest most voted

answered 2015-01-16 22:23:39 +0100

LogicDaemon gravatar image

updated 2015-03-13 14:19:11 +0100

when pasting, select "text" formatting for the column. Otherwise it's treated as floating-point number, and precision is about 10-11 significant digits.

If it doesn't ask, first paste to notepad, writer (as text without formatting) or other text editor, to dispose of HTML table formatting. Then copy it from there and paste to Calc. It will show text import dialogue:

Edit → Paste Special → As unformatted text, if it won't show the dialogue again (it won't if editor you're pasting from something that supports formatting, like LO Write).

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-01-16 21:34:17 +0100

Seen: 197 times

Last updated: Mar 13 '15