[Dr_StrangeTrick]

Two points about this program.

First of all it shows how really difficult it is to try and use a spreadsheet on a mobile phone, no wonder Microsoft did not port Pocket Excel to the SmartPhone platform.

Secondly I'm not sure if its me but I tried a simple vat spreadsheet and unless I have dont it wrong it gets the wrong answer :exclaim:



 vat.zip (159bytes)
Number of downloads: 3796

Attached File(s)

•  Spreadsheet.bmp (147.76K)
  Number of downloads: 191

This post has been edited by Dr_StrangeTrick: 13 January 2005 - 06:06 AM

[Sponsored Links]

[chucky.egg]

Er, yeah, that looks wrong to me!
Maybe accurate calculations come in v1.1

[Confucious]

How do you enter calculations - I've not even managed to get that far yet - but with results like those i'm not sure wether it's worth it!

[martin]

Nice to see a spreadsheet being made

A couple of problems so far.

1 It doesn't seem to include decimal places in calculations

2 It takes too long time to enter formulas. It could probably so with some pre-defined formulas that can be selected and edited.

Apart fromm that it looks quite promising I hope they continue working on it.

[Dr_StrangeTrick]

Hi Confucious, first of all make sure you have downloaded v0.5 (it took me a few times to find it)

Move to which cell you want and begin the entry with = to refer to other cells use [1:2] notation (painful on the smartphone) and enter the formula like in Excel.

E.G. To make COL2 total the contents of COL0 and COL1 use this for the formula...

=[1:1]+[1:2]

[Confucious]

I still had beta 1. Just downloaded Beta 5 -I'll try it. Thanks.

[spyda]

Confucious, on Jan 13 2005, 19:30, said:

I still had beta 1. Just downloaded Beta 5 -I'll try it. Thanks.
<{POST_SNAPBACK}>

Where did you find the Beta 5 version. I searched the site but it's all in a different language.

Please reply with direct link.

-icky

[Confucious]

Try http://www.daycounts...p=mydown&did=17

[spyda]

Confucious, on Jan 13 2005, 21:11, said:

Try http://www.daycounts...p=mydown&did=17
<{POST_SNAPBACK}>

Confucious says...

you the man!

-icky

[gazzaman28]

This is the only spreadsheet available for smartphones? MS should really pull their finger out!
Can anyone understand any of that mobysmart forum and see if he says anything about how he's getting on with development? I'd like to get a SPV C500 but I can't justify getting rid of my Dell Axim unless there's some sort of spreadsheet I can use.

[gglaspi]

Hi everybody,

Sorry for my late contribution to this forum.
I'm the one developping Spreadsheet SP because I also miss Excel on my Smartphone.

Latest version of Spreadsheet SP is currently Beta 5.

Next release will correct som few bugs, increase permormances and maybe a major evolution : the support of XML Spreadsheet generated by MS Excel.

I will let you know.

PS : I'm also working oin translating my website into english. Currently only som technical menus are translated.. not content.

[Dr_StrangeTrick]

I am looking forward to the next version.

[Confucious]

gglaspi - Thanks, we're looking forward to the next version.. Can you explain the calculation discrepancy in Dr_StrangeTrick’s screenshot?

There seem to be quite a few French programmers for the SmartPhone which is great – what is not so great is. What is not so great is the total lack of French speakers among us. I can’t speak for anyone else but for myself I apologise for my lack of language skills and thank you for taking the time and effort to translate into English.

Will you post here when the next version comes out or should we just keep checking your website?

Keep up the good work and welcome to the forums 

[gglaspi]

Confucious, on Jan 16 2005, 09:53, said:

gglaspi - Thanks, we're looking forward to the next version.. Can you explain the calculation discrepancy in Dr_StrangeTrick’s screenshot?

Hi guys,

The calculation issue was related to the decimal separator (french is a coma while english is a point)
This should be solved but could not test it.
Could you do give me a feed back here ?

Thx

This post has been edited by gglaspi: 07 February 2005 - 05:08 PM

[Phil Lee]

I'm planning my wedding at the moment and have a spreadsheet with all the costs on it on my laptop. I decided to install your beta for the first time today to see if I could use it to keep track of the costs on the move. First impressions are that the product is a good start. I have encountered several problems with it and have some general comments and suggestions which I've made below. I fully understand that this is a free beta app but felt that you might find some feedback useful.

For your information I'm running the spreadsheet on an Orange C500 with the latest UK ROM update installed and am using English as my preferred language in your program.

Problems

1. The program doesn't handle CSV's with blank lines in. If I load a CSV in with three blank lines in between 2 sets of data the program only displays the first set of data. When importng the same spreadsheet I had a series of cells with (null) in it.

2. When I change the value of a cell the change doesn't show up in the main spreadsheet area, it only shows in the edit area. If I save and reopen the file the change is shown correctly.

3. When you exit the program it doesn't prompt you to save the file you are working on.

4. Option 7 under the main menu has no function.

5. You can copy a cell but you can't paste it since there is no key to do that.

Comments

1. I'm not sure you can use the official MS Excel icon for the program.

2. I don't think there is a need to change the seperator using the 1 key. I repeatedly found myself pressing 1 to enter a number only to find that the spreadsheet had changed to a single column sheet.

Suggestions

1. On the open file option you should be able to click on a file to open it.

2. It would be nice to have a most recent files opened list to speed up opening of spreadsheets

3. It would be nice if the program displayed currency symbols.

4. It would be nice to be able to rotate the display to landscape mode.

5. It would be nice if the program displayed column letters and row numbers.

6. It would be nice to be able to use the Back key to delete the contents of a cell.

7. It would be nice to be able to move to a cell then type into it straight away.

8. The program should default to 123 mode for data entry.

9. It would be nice if the program worked like Excel and allowed you to select a cell, type = then move the cursor to the cell you want to use in a calculation.

10. It would be nice if the program did date calculations.

11. The program should show the current file name in the title bar.

12. Get rid of the Exit menu and add it to the right hand menu. This will give you another complete menu to do more stuff with.

13. Is the Pocket Excel file format (.pxl) an open standard? If it is it would be great if the spreadsheet could use that. That way when we copy data from PC to phone, ActiveSync will automatically change the format.

This post has been edited by Phil Lee: 27 January 2005 - 03:12 PM

[gglaspi]

Wouaou !!
That is more than simple unit testings !!!

Ok, first of all, I would need to know witch version of Spreadsheet SP you are using.

Here are below some comments

Phil Lee, on Jan 27 2005, 14:55, said:

I'm planning my wedding

Best wishes !!!

Phil Lee, on Jan 27 2005, 14:55, said:

1. The program doesn't handle CSV's with blank lines in. If I load a CSV in with three blank lines in between 2 sets of data the program only displays the first set of data. When importng the same spreadsheet I had a series of cells with (null) in it.

Will have a look

Phil Lee, on Jan 27 2005, 14:55, said:

2. When I change the value of a cell the change doesn't show up in the main spreadsheet area, it only shows in the edit area. If I save and reopen the file the change is shown correctly.

3. When you exit the program it doesn't prompt you to save the file you are working on.

Should be solved in v1.0

Phil Lee, on Jan 27 2005, 14:55, said:

4. Option 7 under the main menu has no function.

5. You can copy a cell but you can't paste it since there is no key to do that.

Copy and paste uses same shortcut key : 3
You can paste only if you copied first

Phil Lee, on Jan 27 2005, 14:55, said:

1. I'm not sure you can use the official MS Excel icon for the program.

I'll try to make my own ican

Phil Lee, on Jan 27 2005, 14:55, said:

2. I don't think there is a need to change the seperator using the 1 key. I repeatedly found myself pressing 1 to enter a number only to find that the spreadsheet had changed to a single column sheet.

Agree

Phil Lee, on Jan 27 2005, 14:55, said:

Suggestions
........
........

Y'll see !!! get married first and then you will understand !

:mrgreen:

[Phil Lee]

I installed the latest version. On the splash screen it says Spreadsheet SP (v1.0). Sorry about all the comments and suggestions but you did ask for feedback

[gazzaman28]

Apologies if I'm being a bit thick here, but what do I do with the files once they are downloaded?!

[TKJ]

gazzaman28, on Jan 27 2005, 18:43, said:

Apologies if I'm being a bit thick here, but what do I do with the files once they are downloaded?!
<{POST_SNAPBACK}>

You should only get one file. It is a .cab file, which means that you place it somewhere on your phone and then with the phones filemanager you find the file where you put it and click it, it then installs by it self

TKJ

[TKJ]

I have been using this program every day since it was posted here and I have gotten used to some of the problems mentioned I really missed a program like this, and I hope you will continue the work. If not, I will continue to use your version 0,5. I think this is the only free app where you can make and work with spreadsheets on the phone..?

Quote

Problems

1. The program doesn't handle CSV's with blank lines in. If I load a CSV in with three blank lines in between 2 sets of data the program only displays the first set of data. When importng the same spreadsheet I had a series of cells with (null) in it.

I just dont make any empty lines but this is a problem that I have noticed too
It is a problem if you forget something and wants to make a new line, it is not possible.. The new empty line is placed in the bottom of the spreadsheet..

Quote

2. When I change the value of a cell the change doesn't show up in the main spreadsheet area, it only shows in the edit area. If I save and reopen the file the change is shown correctly.

This is "new". It is not a problem in the version 0,5. This doesn't work for me, so the old version is better..

Quote

3. When you exit the program it doesn't prompt you to save the file you are working on.

No, and it doesn't in the new version either. It is not a big problem for me, but would be nice

Quote

5. You can copy a cell but you can't paste it since there is no key to do that.

No.. and I this is a much wanted function! There is no reason to be able to copy if there is no paste function.. It sounds as if there is one, but where do I find it?

Besides these things, I have problems importing ANYTHING from my computers excel to the phone spreadsheet. Even if I save it as .csv, which is what the phones spreadsheet names them, it doesn't work.
The file has to be created on the phone and I can then (If I'm lucky.. I still havent found out why some documents work and some doesn't!?) write some text in the spreadsheet on the computer and then transfer it back, but if I try to put in any numbers, it doesn't work..
This is a bit annoying because it can be complicated putting in all of the info on the phone.
This is what I have in one field:

Quote

=[2:3]+[3:3]+[4:3]+[5:3]+[6:3]+[7:3]+[8:3]+[9:3]+[10:3]+[11:3]+[12:3]+[13:3]+[14
3]+[15:3]+[16:3]+[17:3]+[18:3]+[19:3]+[20:3]+[21:3]+[22:3]+[23:3]+[24:3]+[25:3]+
26:3]+[27:3]+[28:3]+[29:3]+[30:3]+[31:3]+[32:3]+[33:3]+[34:3]+[35:3]+[36:3]+[37:
]+[38:3]+[39:3]

So I would LOVE being able to chose a "sum up" function or a copy paste function instead of putting all of this in on the phone "manually"

The bottom line calculates in my spreadsheet, and when I put in anything, the "cursor" ends in the bottom and I have to move back up where I was editing.

I have worked often with excel on the computer, but the calculating bit in the phones spreadsheet is different, so I can't transfer the "calculating" fields from the computer to the phone..
The spreadsheet can't calculate if there is nothing in some of the fields. There must be a 0 (or another number )

Then there is the thing that sometimes it calculates wrong I can see that this is because of the 0,5 og 0.5.. i guess..

I think this was my comments for now. The program is much needed and I really appreciate it

TKJ

[Sponsored Links]