Problems sorting colums in numbers

Discussion in 'New Member Introductions - Site Assistance' started by Heilsxm, Dec 13, 2012.

  1. Heilsxm

    Heilsxm
    Expand Collapse
    iPF Novice

    Joined:
    Dec 13, 2012
    Messages:
    10
    Thanks Received:
    0
    When i try to sort a column it returns to the original order in a fraction of a second. What am i doing wrong?
     
  2. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,753
    Thanks Received:
    4,750
    Strange. Without seeing the spreadsheet I can only throw out the usual fixes. If they don't work, describe what you are doing in more detail, or if there is no private data involved upload the file to a cloud service and share the link. I'd be happy to take a look and see if it happens on my iPad too.

    -----------

    The usual fixes:

    When you have problems with an app it's a good idea to clear it from RAM.

    Close/Clear the app: With the problem app closed, double tap on the Home button to get the multitask bar. Tap and hold on any icon in the bar until they jiggle, then tap the minus sign on the problem app. This will remove it from RAM and insure a clean start the next time you launch the app.

    If that does not work try a restart,

    Restart: Hold down the power button until the power off slider appears. Slide it off. When the iPad finishes shutting down, hold down the power button again until the Apple logo appears. Apple recommends you restart the iPad at least once a month.

    and then a reset if that does not work.

    Reset: Hold down the power and home buttons until the Apple logo appears. The iPad will reboot. This usually takes a bit longer than a restart. takes a bit longer than a restart.

    Reset All Settings: Another, somewhat more drastic thing you can do is Reset All Settings. You'll find this under Settings > General > Reset > Reset All Settings. It won't erase any of your content, apps, or accounts; but you will have to go through most of your other settings and re-tweak them back to your liking.
     
  3. Heilsxm

    Heilsxm
    Expand Collapse
    iPF Novice

    Joined:
    Dec 13, 2012
    Messages:
    10
    Thanks Received:
    0
    Hi Twerppoet


    thanks,

    I have tried everything except the complete reset, but to no avail. I' d love you to have a look at it, if only I knew how to add it to a cloud service.
     
  4. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,753
    Thanks Received:
    4,750
    Reset all Settings is unlikely to solve this problem anyway. I just didn't delete it when I copy/pasted it from my notes.

    Well, first you need a cloud service. I recommend either Dropbox as the easiest to use. I also like Box.com with it's extra features and options, but it takes a bit more to learn it's features.

    Once you have the account, download the companion app (from the App Store) to you iPad, open it, and sign into your account.

    In Numbers, go to the document page, choose Edit, select the spreadsheet, tap the share icon at the top left (box with arrow), and choose Open in Another App. Make sure you select the Numbers format. When it is done exporting tap the Choose App button and select the cloud app (DropBox, presumably).

    The cloud app will open, and give you some save options; the ability to change the file name and/or folders to save in, usually.

    Select the newly uploaded file in the app. It will probably download it.

    Somewhere in the app you should see the Share icon; a box with a curved arrow coming out of it. It's the first of the three icons at the top right in DropBox. Tap in and choose Copy Link to Clipboard {if you chose a service other than DropBox, the menthod of copying the share URL will vary from this}.

    Now all you have to do is paste the URL into your post when replying to the thread.


    If you are posting from a computer, you can access your DropBox account from a browser, and/or download and install the DropBox app on the computer. You'll be able to generate and paste the share URL using those tools as well.

    Oh, I see you only have 2 posts so far. You'll need to make one post more before the forum will let you paste a link. This limit helps keep the spam bots away.
     
    #4 twerppoet, Dec 13, 2012
    Last edited: Dec 13, 2012
  5. Heilsxm

    Heilsxm
    Expand Collapse
    iPF Novice

    Joined:
    Dec 13, 2012
    Messages:
    10
    Thanks Received:
    0
    Thanks again,


    I will paste the link in the next post.

    I am trying to sort the results table by percentage. I was unable to so I used ranking instead, but I can still not sort that column I think everything else should be pretty basic for you.
     
  6. Heilsxm

    Heilsxm
    Expand Collapse
    iPF Novice

    Joined:
    Dec 13, 2012
    Messages:
    10
    Thanks Received:
    0
  7. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,753
    Thanks Received:
    4,750
    Ok. I'll go take a look.
     
  8. twerppoet

    twerppoet
    Expand Collapse
    iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    19,753
    Thanks Received:
    4,750
    I can't duplicate the problem. All the columns I tried would sort. It played havoc with your formulas (tons of errors appear) but the columns sorted, and stayed sorted. Well, until I tapped lots of Undos to clean things back up. I wonder if the app is trying to protect your formulas' integrity.

    What columns were you trying to sort?

    What version of iOS are you running?

    If iOS6, are you running the latest version of Numbers?


    Here is your file back.

    https://www.dropbox.com/s/dcop87rdvqhqtd4/Results 121212_1.numbers

    Try re-importing it to Numbers and see if the problem persists, or gets worse for all I know. The only thing I changed (on purpose) was to increase Table 1's header rows to 2 and footer rows to 4; so they would not sort along with the scores.
     
  9. Heilsxm

    Heilsxm
    Expand Collapse
    iPF Novice

    Joined:
    Dec 13, 2012
    Messages:
    10
    Thanks Received:
    0
    Hi here,


    Thanks for your efforts.
     
  10. Heilsxm

    Heilsxm
    Expand Collapse
    iPF Novice

    Joined:
    Dec 13, 2012
    Messages:
    10
    Thanks Received:
    0
    I am running iOS 6.0.1 numbers V 1.7.1 (741)

    I am trying to sort the table RESULTS columns % or rank, but the error repeats itself. Even the names will not sort. Here is what I do: I touch a cell in a table to have the bars outside the table come up. Then I click on SORT above the primary column I want to sort by, then ASCENDING and voila, nothing..
    It is not really that important, but I would like to understand if I am doing something wrong.
    Txs
     

Share This Page



Search tags for this page

numbers

,

numbers ipad sort column