View Full Version : Blank spreadsheets in PC
notovitz
November 21st, 2001, 12:49 PM
I am using TinySheet version 4.02, build 146. I created a spreadsheet in my Palm 505 by "importing" sheet data from the memo pad. The "export" to memo pad was created using AllTime's reporting application. Each time I do a synch, the following error repeats for each "cell":
Workbook Time on Palm contains a cell that could not be transfered to the PC because it contains an error that Excel will not accept.
My spreadsheet in the PC is of course, blank. Please tell me how fix this problem.
MoonCactus
November 22nd, 2001, 12:53 AM
May be some of your cells are starting with equal sign, in that case TS tries to export it as a formula to Excel. TS can support wrong formulas but Excel cannot so the cell is not exported.
If you have leading equal sign but the content is not a formula, try to add a single quote in front of content.
Hope it helps!
notovitz
November 22nd, 2001, 02:34 AM
Thank you for your reply, but all my cells contain simple numbers with apostrophes preceeding them. I even "manually" added a cell with these numbers - "3384" (without the quotes) and the entire spreadsheet is blank. For every single cell I'm getting this message upon synching:
Workbook Time on Palm contains a cell that could not be transfered to the PC because it contains an error that Excel will not accept.
vladimir
November 26th, 2001, 02:10 AM
Try to set up cells format to General or Numeric on the Palm using Cell menu | Format | Number.
notovitz
November 26th, 2001, 03:48 AM
I do not know why, but this did the trick! Many thanks.
vBulletin® v3.7.4, Copyright ©2000-2010, Jelsoft Enterprises Ltd.