docs to go spreadsheet issue

Discussion in 'iPad Help' started by dough54321, Jan 27, 2011.

  1. dough54321
    Offline

    dough54321 iPF Novice

    Joined:
    Jun 5, 2010
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Augusta, GA
    Ratings:
    +0 / 0
    I've put this on their forum. But no one is answering. Thought I'd try here...

    Whenever I input a negative number into a cell, like -2.22, instead of what I type, I get something like 2E.+0. It doesnt seem to affect any calculations and when I highlight the cell -2.22 still shows up in the edit cell frame.

    I've even tried using parenthesis instead, (2.22), but then it makes it '-2.22 in the frame and doesn't recognize it as a number box anymore for calculations. I'm guessing because it ads the apostrophe before the number.

    Could you tell me what I'm doing wrong?
  2. sch
    Offline

    sch iPad Fan

    Joined:
    Jun 2, 2010
    Messages:
    118
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    Check the cell formatting. Sounds like it's in Scientific notation rather than Number.

    Cheers,
  3. dough54321
    Offline

    dough54321 iPF Novice

    Joined:
    Jun 5, 2010
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Augusta, GA
    Ratings:
    +0 / 0
    All I'm doing is putting -2.33 in the field when the weird sequence pops up.
  4. sch
    Offline

    sch iPad Fan

    Joined:
    Jun 2, 2010
    Messages:
    118
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    As I said, check the cell formatting. Sounds like it's in Scientific notation rather than Number.

    Tap on the cell and then formatting icon on the lower toolbar (2nd from left), click " ...More", then the "12" in the popup title bar, then "Category" and choose "Number", then "Done".
  5. dough54321
    Offline

    dough54321 iPF Novice

    Joined:
    Jun 5, 2010
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Augusta, GA
    Ratings:
    +0 / 0
    As soon as I select "category" the program freezes. Happened four times now.

    Thanks for the help. I didn't get what you were saying earlier.
  6. sch
    Offline

    sch iPad Fan

    Joined:
    Jun 2, 2010
    Messages:
    118
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    Try a reboot on the iPad: Hold down both buttons until the chrome Apple logo shows (takes about 10 full seconds, so keep holding both buttons until the logo). After this the iPad restarts and this will cure almost all issues that aren't app-based.

    Ciao,
  7. dough54321
    Offline

    dough54321 iPF Novice

    Joined:
    Jun 5, 2010
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Augusta, GA
    Ratings:
    +0 / 0
    Did the reboot. Still freezing unfortunately. :(
  8. sch
    Offline

    sch iPad Fan

    Joined:
    Jun 2, 2010
    Messages:
    118
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    Last thing I'd try is to recreate the file. Sounds as if the file is corrupt, unless you have this issue with other sheets too?
  9. dough54321
    Offline

    dough54321 iPF Novice

    Joined:
    Jun 5, 2010
    Messages:
    10
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Augusta, GA
    Ratings:
    +0 / 0
    Opened a different file. Still crashing. I'll try a brand new file next...
  10. sch
    Offline

    sch iPad Fan

    Joined:
    Jun 2, 2010
    Messages:
    118
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    Do you have the latest version of the app? This works on mine without an issue.

    Try deleting the app from your iPad and downloading it again (you don't get charged).

    Ciao,
    Last edited: Jan 29, 2011

Share This Page

Search tags for this page
can you highlight cells in docs to go
,
cannot select mulitple cells in docs to go
,
cannot select multiple cells on excel on docs to go on ipad
,
copy and paste cells excel ipad documents to go
,
copy cells docs to go excel ipad
,
copy excel sheet in ipad docs to go
,

docs to go ipad cannot select multiple cell

,
docs to go spreadsheet select multiple cells
,

documents to go excel copy page

,
excel
,
how to format cells in docments to go for ipad
,
how to multiply cells in docs to go for ipad
,

how to select multiple cells in docs to go

,
how to select multiple cells in documents to go ipad
,
how to select multiple cells on ipad in docs to go
,

select all cells in docs to go

,
select multiple cells in docs to go
,

select multiple cells in documents to go

,
select multiple cells on ipad docsto go
,
select multiple rows in docs to go