Ask Your Question

Pasting from website in calc looses data

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

juanc 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 close merge delete

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 159 times

Last updated: Mar 13 '15