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!
Full Version: How To Retain Spreadsheet Formulas When Saving To Disc?
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!
If you want to give Firefox a try, here's an extension that might do what you need:
Table2Clipboard
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.
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.