Ask Your Question
0

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:

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 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
1

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: 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

Question Tools

1 follower

Stats

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

Seen: 197 times

Last updated: Mar 13 '15