Welcome to iPadForums.net Guest - Click Here to Register

docs to go spreadsheet issue

This is a discussion on docs to go spreadsheet issue within the iPad Help forums, part of the Apple iPad Discussions category; 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 ...

Register with iPad Forums
+ Reply to Thread
Results 1 to 10 of 10
  1. #1
    iPF Novice
    Member #
    6096
    Join Date
    Jun 2010
    Location
    Augusta, GA
    Posts
    10

    docs to go spreadsheet issue

    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. Ads


  3. #2
    sch
    sch is offline
    iPad Fan
    Member #
    5838
    Liked
    2 times
    Join Date
    Jun 2010
    Posts
    118
    Check the cell formatting. Sounds like it's in Scientific notation rather than Number.

    Cheers,
    Simon

  4. #3
    iPF Novice
    Member #
    6096
    Join Date
    Jun 2010
    Location
    Augusta, GA
    Posts
    10
    All I'm doing is putting -2.33 in the field when the weird sequence pops up.

  5. #4
    sch
    sch is offline
    iPad Fan
    Member #
    5838
    Liked
    2 times
    Join Date
    Jun 2010
    Posts
    118
    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".
    Simon

  6. #5
    iPF Novice
    Member #
    6096
    Join Date
    Jun 2010
    Location
    Augusta, GA
    Posts
    10
    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.

  7. #6
    sch
    sch is offline
    iPad Fan
    Member #
    5838
    Liked
    2 times
    Join Date
    Jun 2010
    Posts
    118
    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,
    Simon

  8. #7
    iPF Novice
    Member #
    6096
    Join Date
    Jun 2010
    Location
    Augusta, GA
    Posts
    10
    Did the reboot. Still freezing unfortunately.

  9. #8
    sch
    sch is offline
    iPad Fan
    Member #
    5838
    Liked
    2 times
    Join Date
    Jun 2010
    Posts
    118
    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?
    Simon

  10. #9
    iPF Novice
    Member #
    6096
    Join Date
    Jun 2010
    Location
    Augusta, GA
    Posts
    10
    Opened a different file. Still crashing. I'll try a brand new file next...

  11. #10
    sch
    sch is offline
    iPad Fan
    Member #
    5838
    Liked
    2 times
    Join Date
    Jun 2010
    Posts
    118
    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 by sch; 01-29-2011 at 10:20 AM.
    Simon


Advertisements

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Similar Threads

  1. ??'s about Excel SpreadSheet & Ipad.
    By Dagwood_55 in forum iPad General Discussions
    Replies: 4
    Last Post: 01-17-2011, 09:52 PM
  2. Spreadsheet
    By mgrovum in forum New Member Introductions - Site Assistance
    Replies: 7
    Last Post: 11-20-2010, 06:31 AM
  3. Which is best spreadsheet apps
    By Monkeynuts in forum iPad Apps
    Replies: 4
    Last Post: 10-28-2010, 11:57 PM
  4. PDF Docs to Itunes
    By marvin.bordelon in forum iPad General Discussions
    Replies: 5
    Last Post: 05-30-2010, 10:51 AM
  5. iWorks and Google Docs Issue
    By AZRaptor in forum iWork Forum
    Replies: 8
    Last Post: 04-16-2010, 01:17 PM

Search tags for this page

docs to go ipad cannot select multiple cell

,

docs to go ipad spreadsheet cell format

,

docs to go select multiple cells

,

documents to go copy sheet

,

highlite multiple ares in spread sheet on ipad

,
hilight range in docs to go
,

how to copy sheet in doctogo

,

how to select multiple cells in docs to go

,
how to select range in ipad docs to go
,

select multiple cells google ipad

,
select multiple rows in docs to go
,
selecting range in excel in docs to go ipad
Click on a term to search for related topics.