Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, 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.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

How To Retain Spreadsheet Formulas When Saving To Disc?


  • Please log in to reply
1 reply to this topic

#1 rodell

rodell

  • Members
  • 21 posts
  • OFFLINE
  •  
  • Local time:01:54 AM

Posted 14 October 2007 - 05:57 PM

:thumbsup: 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!

BC AdBot (Login to Remove)

 


#2 tg1911

tg1911

    Lord Spam Magnet


  • Members
  • 19,274 posts
  • OFFLINE
  •  
  • Gender:Male
  • Location:SW Louisiana
  • Local time:12:54 AM

Posted 15 October 2007 - 08:27 AM

If you want to give Firefox a try, here's an extension that might do what you need:
Table2Clipboard

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.


MOBO: GIGABYTE GA-MA790X-UD4P, CPU: Phenom II X4 955 Deneb BE, HS/F: CoolerMaster V8, RAM: 2 x 1G Kingston HyperX DDR2 800, VGA: ECS GeForce Black GTX 560, PSU: Antec TruePower Modular 750W, Soundcard: Asus Xonar D1, Case: CoolerMaster COSMOS 1000, Storage: Internal - 2 x Seagate 250GB SATA, 2 x WD 1TB SATA; External - Seagate 500GB USB, WD 640GB eSATA, 3 x WD 1TB eSATA

Become a BleepingComputer fan: Facebook




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users