 How To Retain Spreadsheet Formulas When Saving To Disc?, WinXP IE7 Copy/Paste difficulty |
Welcome Guest ( Log In | Click here to Register a free account now! )
Register a free account to unlock additional features at BleepingComputer.com
Welcome to Bleeping Computer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.  |
 Oct 14 2007, 05:57 PM
Post
#1
|
|
|
Member  Group: Members Posts: 15 Joined: 5-July 05 Member No.: 25,940  |
 My problem is to retain all FORMULAS on a Spreadsheet file when Save As to any other location, particularly to CD discs. Save easily, but without a single formula, and there are in excess of a hundered of them. At my inexperience level I avoid anything drastic such as reinstalling Office or whatever. The method I have used successfully is: 1. Highlight any cell with a formula.2. Go to any empty cell and Edit/Copy.3. Right click/select Paste Special.4. Click Formulas.5. Click Escape twice.6. Click keyboard Delete to empty that cell. But now all is lost by inability to use the Paste Special grayed out item. I do hope one of you experts can help with this. And if, in addition, you have another means of retaining spreadsheet formulas when saving elsewhere so much the better. Thanks!
|
 |
 
|
|
Oct 15 2007, 08:27 AM
Post
#2
|
|
 SPAM Magnet Group: Site Admin Posts: 14,437 Joined: 6-May 04 From: SW Louisiana Member No.: 363 |
If you want to give Firefox a try, here's an extension that might do what you need:
Table2Clipboard QUOTE Mozilla applications allow to select rows and columns from a table simply pressing Control key and picking rows/columns with left mouse button.
The selection can be copied to clipboard but the original table disposition is lost making ugly results when you paste the text on data sheet applications (eg excel). If you want to paste data in Microsoft Excel on OpenOffice Calc with correct disposition simply use Table2Clipboard. -------------------- I love being married.
It's so great to find that one special person you want to annoy, for the rest of your life. |
|
|
|
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
| Lo-Fi Version | Time is now: 8th January 2009 - 10:31 PM |
© 2003-2008 All Rights Reserved Bleeping Computer LLC.