PasteAsValue

×

Warning message

This extension was not updated recently. It might not work with latest versions of OpenOffice.

Primary tabs

Maintainer:
yookee
Rating:
3.75

Average: 3.8 (4 votes)
Application:
Writer
Tags:
table, extension, spreadsheet, extension, paste, extension
Post date:
Sunday, 15 August, 2010 - 13:19
Statistics
 Week: Not tracked - Month: Not tracked - Year: Not tracked - Timeline
Download extension
Windows version - All releases
Compatible with OpenOffice 4: Unknown
User feedback:
Compatible with OpenOffice 4.x?

A very simple extension act as title.

Paste only numerical value or text copied from Excel or Calc to table in Writer without rich format.
General Paste and Paste Special can't do one cell to one grid.

Usage:

  1. Copy from Excel or Calc, one cell or a range of cells
  2. Place cursor where you want to paste in Writer
  3. Select PasteAsValue from Edit menu or Standard toolbar
  4. Select "Paste as text" or "Paste as numeral"
  • Set decimal digits for numeral

Tips:
You can choose version between 0.2 and 0.3.x as your favor.
But in ver 0.2:

  • If the cursor isn't in a table, it will do nothing
  • If copied range of cells is larger than the table, it may not act as your expectations
  • If the table isn't empty, it may not act as your expectations

PasteAsValue

Version Operating system Compatibility Release date
0.3.4 Windows, Linux, Linux x86-64 3.4 16/09/2010 - 11:32 More information Download
0.3.3 Windows, Linux 3.4 30/08/2010 - 22:20 More information Download
0.3.2 Windows, Linux 3.4 30/08/2010 - 11:03 More information Download
0.3.1 System Independent 3.4 29/08/2010 - 21:18 More information Download
0.3 Windows, Linux 3.4 29/08/2010 - 11:41 More information Download
0.2 Windows, Linux 3.4 22/08/2010 - 01:07 More information Download
0.1 Windows 3.4 15/08/2010 - 13:56 More information Download

Comments

Submitted by Anonymous (not verified) on 26 September, 2010 - 15:13

Hello!

I just found if there are empty cells in the copied list, pasteasvalue ends with error during paste operation.

Good luck!

Andis

Log in or register to post comments
Submitted by Anonymous (not verified) on 14 September, 2010 - 14:06

Thanks for a very useful addon but unfortunately:

OOo 3.2.1 (official, not Ubuntu packaged version) 32bit Ubuntu 9.04 32 bit installs & works fine but like krabina said the message "this file does not run on this computer" is displayed when using Extension Manager to install on Ubuntu 10.04 amd64 OOo 3.2.1 (official, not Ubuntu packaged version).

Log in or register to post comments
Submitted by Anonymous (not verified) on 30 August, 2010 - 01:34

I don't like the automatic table feature that has been introduced in 0.3 version

I prefer 0.2 version which pastes only text

Log in or register to post comments
Submitted by Anonymous (not verified) on 26 August, 2010 - 14:37

Trying to open the file on Ubuntu 10.04 with the extension manager of OOo 3.2.0 results in a message "this file does not run on this computer" (roughly translated from German).

Log in or register to post comments
Submitted by Anonymous (not verified) on 26 August, 2010 - 00:59

This feature is what makes significant difference between Word & Excel and Writer & Calc combination. I hope this extension will work also with complicated tables.

Best regards!

Log in or register to post comments