Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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 show parse dialogue, first paste to notepad, (as text) to writer, 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/Text_Import

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 show parse dialogue, first paste to notepad, (as text) to writer, 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/Text_Import

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

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 show parse dialogue, first paste to notepad, (as text) to writer, 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/Text_Import

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

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 show parse dialogue, ask, first paste to notepad, writer (as text) to writer, 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/Text_Import

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

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/Text_Import

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).