PasteAsValue

×

Message d'avertissement

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

Onglets principaux

Maintainer:
yookee
Note:
3.75

Average: 3.8 (4 votes)
Application:
Writer
Étiquettes:
table, extension, spreadsheet, extension, paste, extension
Date de publication:
Dimanche, 15 Août, 2010 - 13:19
Statistiques
 Week: Non suivi - Mois: Non suivi - Année: Non suivi - Timeline
Download extension
Windows version - All releases
Compatible with OpenOffice 4: Inconnu
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 Plus d'information Download
0.3.3 Windows, Linux 3.4 30/08/2010 - 22:20 Plus d'information Download
0.3.2 Windows, Linux 3.4 30/08/2010 - 11:03 Plus d'information Download
0.3.1 System Independent 3.4 29/08/2010 - 21:18 Plus d'information Download
0.3 Windows, Linux 3.4 29/08/2010 - 11:41 Plus d'information Download
0.2 Windows, Linux 3.4 22/08/2010 - 01:07 Plus d'information Download
0.1 Windows 3.4 15/08/2010 - 13:56 Plus d'information Download

Commentaires

Soumis par Anonymous (non vérifié) le 26 Septembre, 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

Connectez-vous ou inscrivez-vous pour publier un commentaire
Soumis par Anonymous (non vérifié) le 14 Septembre, 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).

Connectez-vous ou inscrivez-vous pour publier un commentaire
Soumis par Anonymous (non vérifié) le 30 Août, 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

Connectez-vous ou inscrivez-vous pour publier un commentaire
Soumis par Anonymous (non vérifié) le 26 Août, 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).

Connectez-vous ou inscrivez-vous pour publier un commentaire
Soumis par Anonymous (non vérifié) le 26 Août, 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!

Connectez-vous ou inscrivez-vous pour publier un commentaire