Results 1 to 13 of 13
  1. rational_mind's Avatar
    CrackBerry User

    Posts
    60 Posts
    Thread AuthorThread Author   #1  

    Default How to insert ROWs in Sheet to Go

    Perhaps I am showing my lack of working knowledge of spread sheets, but here goes anyway….

    I decided to start a summary log of my daily miles using my PB’s Sheet to Go. I chose a very simple format:

    The 1st row I reserved (and programmed) for a summation (=SUM(A1:A100) of values that are entered daily in the rows below. Then I realized that I want the latest entry ALWAYS to be right under the 1st (summation) row. That requires INSERT ROW function, which for the life of me I could not figure out how to work on my playbook.

    I spent a reasonable amount of time googling and still no progress…

    Has anyone encountered the same problem and can it be solved?

    Many thanx in advance…
  2. kmcobra64's Avatar
    CrackBerry Abuser

    Posts
    316 Posts
    #2  

    Default

    I keep a spreadsheet to log all of the maintenence, work and modifications done to my vehicle and when so i have an accurate history and record of everything in one place.

    I put it on the playbook thinking that this would be great to have on such a portable device and I can just fill everything in as I go. Only problem: It requires and insert row function every time I do work on the Jeep.

    And there isnt one.

    It is such a basic function, I really wish they would add it. Especially since Ive heard the feature is in Docs to Go for Android ... and RIM owns Docs to Go
  3. joaosousa's Avatar
    CrackBerry User

    Posts
    88 Posts
    Global Posts
    89 Global Posts
    #3  

    Default

    Indeed... If there's a way I also didn't find it. You can cut all that's after and paste leaving the desired empty cells but that's hardly practical (for the cell selection to be possible the kb must be hidden then press and hold for the options).

    Since you use Sheets to Go I warn you that are also issues relating predictive texting... See here for more info.

    The limitations in Documents to Go has been one of my two main complaints with the PB since I bought it (the other being how poor Adobe Reader is in even the most basic features). And again it's funny because RIM owns the company which makes the PB office suite and also a pdf reader better than Adobe's (at least under other platforms).
    Last edited by joaosousa; 05-01-2012 at 12:22 PM.
  4. gryphon13's Avatar
    CrackBerry User

    Posts
    14 Posts
    #4  

    Default

    I agree, I was hoping that when 2.0 came out that there would be a fix, but no. I am just surprised as it is such a basic function in a spreadsheet that it should be there.

    I have to launch the spreadsheet first on my phone, insert the rows, etc, save and then open on the playbook. Since I sync with dropbox there is a lot of other steps required in between before I get started again on the playbook.

    A lot of unproductive time wasted for a basic function. At least have the same functionality as the version that came installed on my phone. Since blackberry owns the company, you would think that the version they install on their products would be superior to the versions they offer to other OS's.

    Someone has to get the message to blackberry........
  5. arm3090's Avatar
    CrackBerry Newbie

    Posts
    7 Posts
    #5  

    Default

    I don't know if this will work in the Playbook but I just inserted a row and a column in Spreadsheet To Go in my Torch 9860. Here's how I did it.

    1. Go to edit mode.
    2. Tap and hold on the row below. In your case, rational_mind, tap and hold on row 2.
    3. When the mini menu pops up, select Full Menu.
    4. Select Row > Insert.

    Hope this works on the PB also.
  6. #6  

    Default

    The pb version is awful - just plain simple!
  7. gryphon13's Avatar
    CrackBerry User

    Posts
    14 Posts
    #7  

    Default

    It works just fine on my 9810, just no way to do it on the PB without having to use the phone for that function.

    Overall I am very happy with the Playbook, but for business use this workaround makes a simple edit into a major challenge. Not worth using the spreadsheet on playbook for editing, designed more for viewing attachments, I guess.
  8. rkennedy01's Avatar
    CrackBerry Addict

    Posts
    664 Posts
    #8  

    Default

    Download and install the Android version. Plenty of sources for the APK file, and I'm sure there are converted (BAR) packages available, too.

    RCK
  9. BKillar's Avatar
    CrackBerry Abuser

    Posts
    336 Posts
    #9  

    Default

    You can insert rows with Smart Office as shown in the attached image.
    Attached Thumbnails Attached Thumbnails How to insert ROWs in Sheet to Go-img_00000742.jpg  
    Thanked by:
    Herve5 (01-08-2013) 
  10. Bradwick's Avatar
    CrackBerry Newbie

    Posts
    1 Posts
    #10  

    Default Insert row = cut, then paste

    There is no baked in insert row, but with two easy operations you can do it effectively... These are, wait for it.... Cut and paste. Crazy eh? Who would have thought it was possible?

    It does retain cell formulas too so it works nicely.

    Also... With keyboard off-screen, you can copy a cell with a formula, the select multiple cells and paste the formula to effectively do a "fill-down" type command. Took me a while to realize that works that way. The formula cell reference lock "$" works too.

    All in all, with the above known, it becomes a pretty nifty portable spreadsheet. Just wish programming formulas was much easier compared to typing them out.

    Cheers
  11. da88's Avatar
    CrackBerry Newbie

    Posts
    1 Posts
    #11  

    Default

    This annoys me, I can do so much more (including insert rows) with my curve 9360, but PB docs to go is so basic. I hope the BB10 phones won't have such a limited DTG.
  12. Herve5's Avatar
    CrackBerry Addict

    Posts
    564 Posts
    #12  

    Default

    Quote Originally Posted by BKillar View Post
    You can insert rows with Smart Office as shown in the attached image.
    Seconded. Smart Office is efficient and not costly; it also can create new documents from scratch, which IIRC Docstogo doesn't...
  13. David Burleigh's Avatar
    CrackBerry Newbie

    Posts
    1 Posts
    #13  

    Default

    doesnt work for me cos it just replaces the row not add one. will be side loading the android version i think

Posting Permissions