Ask Your Question
0

Pasting from website in calc looses data

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

juanc gravatar image

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

8954318143175030894

when I paste into LibreOffice Calc I get this number,

8954318143175030000

I want to obtain the full text.

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

LogicDaemon gravatar image

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

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: https://help.libreoffice.org/Common/T...

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

Stats

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

Seen: 151 times

Last updated: Mar 13 '15