1. conbrio29's Avatar
    Is there any way to create Microsoft Excel spreadsheets, complete with functions like having it add up a column of values? Can't quite figure this out!

    Posted via the Z30 on CB10
    01-05-14 05:58 AM
  2. texn884's Avatar
    This does not have the same user friendly aspects like it did on my 9930. I am not sure I am going to use it anymore.

    Frustrated here
    01-05-14 06:18 AM
  3. GSM-S's Avatar
    Check out Kingsoft Office in BlackBerry World! You can find it at http://appworld.blackberry.com/webst...ntent/34101314

    Posted via CB10 on my Z10.
    Trishal Shetty likes this.
    01-06-14 02:54 AM
  4. Barljo's Avatar
    Is there any way to create Microsoft Excel spreadsheets, complete with functions like having it add up a column of values? Can't quite figure this out!

    Posted via the Z30 on CB10
    You need to type:-
    Code:
    =sum(a1:a6)
    Where "a1" is the first cell you're including in the sum and "a6" is the last.

    Enjoy!
    01-06-14 04:00 AM
  5. conbrio29's Avatar
    So then what would the formula look like?

    Posted via the Z30 on CB10
    01-07-14 07:20 AM
  6. Bungalow_Bill's Avatar
    The formula would look like this,

    =sum(a1:a6)

    Note the colon between the two cell addresses.

    Posted via CB10
    Ray UM likes this.
    01-07-14 04:25 PM
  7. conbrio29's Avatar
    The formula would look like this,

    =sum(a1:a6)

    Note the colon between the two cell addresses.

    Posted via CB10
    Thanks this helps a lot! Is there any way for someone to add this kind of formula in a user friendly way, or does he or she just have to know this kind of code?

    Posted via the Z30 on CB10
    01-07-14 06:12 PM
  8. cjcampbell's Avatar
    Thanks this helps a lot! Is there any way for someone to add this kind of formula in a user friendly way, or does he or she just have to know this kind of code?

    Posted via the Z30 on CB10
    It's the standard excel code. It's something that takes a little bit of learning but not overly complicated for the basics. Here is a link that should help out with some of the stuff to make using excel a little easier.

    Examples of commonly used formulas - Excel - Office.com
    Ray UM and Barljo like this.
    01-07-14 06:22 PM
  9. conbrio29's Avatar
    Okay thanks for the replies everyone. I guess the Docs to Go does indeed do functions like adding up values, but one just needs to know the codes.

    Posted via the Z30 on CB10
    01-07-14 06:57 PM
  10. cjcampbell's Avatar
    Okay thanks for the replies everyone. I guess the Docs to Go does indeed do functions like adding up values, but one just needs to know the codes.

    Posted via the Z30 on CB10
    Yup... just like Excel for Windows (which this is the mobile version of) or Numbers for Mac... you need to know the formulas in order to make the cells do what you want them to.
    01-07-14 07:16 PM
  11. conbrio29's Avatar
    So I started using Kingsoft Office and it really is a great app. It allows me to insert a new row or column.

    With Docs To Go, how does one insert a new row or column into a spreadsheet?

    Posted via the Z30 on CB10
    01-08-14 04:09 AM
  12. Bungalow_Bill's Avatar
    Unfortunately, there's no way to insert a row or column easily (yet?). The only way that I know is to cut one section and paste it one cell (or more) over. It's an otherwise useful app, which I use often, but I do miss that very basic feature.

    Posted via CB10
    Barljo likes this.
    01-09-14 03:41 AM
  13. Jaimin Shah's Avatar
    Hey,

    How do you view hidden text of .docx /. Doc files in Docs to go?

    Thhis is really urgent and important for me! Pls help

    Narendra Modi for PM and Congress free India 2014
    02-20-14 01:14 PM
  14. chiphazard's Avatar
    You need to type:-
    Code:
    =sum(a1:a6)
    Where "a1" is the first cell you're including in the sum and "a6" is the last.

    Enjoy!
    Lotus 123, hehe

    BlackBerry Since 2006. Rogers Halifax, NS - Official 10.2.1
    02-20-14 01:19 PM
  15. jaycook1989's Avatar
    Is there any way to create Microsoft Excel spreadsheets, complete with functions like having it add up a column of values? Can't quite figure this out!

    Posted via the Z30 on CB10
    Are you trying to finding the BB App for editing Excel file? This article may offer some help.
    Top Excel for BlackBerry Apps
    03-24-14 10:12 PM
  16. guygardner73's Avatar
    Are you trying to finding the BB App for editing Excel file? This article may offer some help.
    Top Excel for BlackBerry Apps
    That's a useful article, but not for BlackBerry 10 though.

    Z10STL100-2/10.2.1.2141 O2 UK
    03-24-14 10:36 PM
  17. ALToronto's Avatar
    D2G has the most commonly used spreadsheet functions, but you need to type them in manually, including cell addresses. You can't just tap on a cell and have its address entered in a formula. I've griped about it since OS7, but no luck so far.

    You also cannot use advanced functions such as statistics, matrix operations or programming. In general, I find it easier to set up the spreadsheet on a real computer and then copy it onto the phone.
    03-24-14 10:47 PM

Similar Threads

  1. How to test App on real device
    By AndiS1983 in forum Developers Lounge
    Replies: 10
    Last Post: 01-11-14, 04:34 PM
  2. BlackBerry 10.2.2 to be the official release??
    By swapnilsj in forum BlackBerry 10 OS
    Replies: 30
    Last Post: 01-07-14, 01:24 AM
  3. Would it be better/worse to switch from Curve 8520 to 9000?
    By Kiel1234 in forum BlackBerry Bold Series
    Replies: 4
    Last Post: 01-05-14, 09:16 PM
  4. How to Get the Backdoor in 1925
    By BriniaSona in forum BlackBerry 10 OS
    Replies: 7
    Last Post: 01-05-14, 05:54 PM
  5. Ipa to apk
    By Bllaca Enis in forum General BlackBerry News, Discussion & Rumors
    Replies: 4
    Last Post: 01-05-14, 06:54 AM
LINK TO POST COPIED TO CLIPBOARD