Spreadsheet SP Beta

[Guest badboy4life]

Just seen this over at MobiSmart:

Google Translation:

As what it was useful to announce the a little front contest, since Jeremy Magne a member of the forum (pseudo: gglaspi), proposes his creation to us and that starts rather very extremely in software quality!

Spreadsheet SP is spreadsheet making it possible to publish textual files with format CSV (Comma Separated Values).

- Systems: Smartphone 2003 only.

- recognized Separators: the point comma (:D, the comma (), the stick (|).

- Languages available: French, English

- Functions: to open, close, record, new file.

- Modifications: Cell, Ajouter/supprimer of the lines, Ajouter/supprimer of the columns.

- Posting: Afficher/masquer the line of the headings.

Spreadsheet SP is thus proposed in its first Beta version, naturally its author await your remarks and suggestions through forum of MobiSmart in order to improving the software and which it answers the user expectations.

Link: MobiSmart

[EDIT]

Forgot to add This Link earlier. It appears that the application is on beta v5! (Link in French, Translation doesn't seem to work)

[/EDIT]

Edited January 10, 2005 by badboy4life

[Guest chucky.egg]

Is this what I think it is! :D/

Will have to give it a try tomorrow, and I'm not sure that it does any calulations or anything, but on the face of it... it's only a bloody spreadsheet app for the Smartphone isn't it!

Cool! :D

Shame on MS for not coming up with something like this before!

[EDIT]

Looks like it DOES do calculations, based on the screenshot here:

http://www.daycounts.com/sections.php?op=l...ticles&secid=18

[/EDIT]

Edited January 10, 2005 by chucky.egg

[Guest blewer]

Fantastic. And about time

Good work :D

[Guest 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

Spreadsheet.bmp

Edited January 13, 2005 by Dr_StrangeTrick

[Guest chucky.egg]

Er, yeah, that looks wrong to me!

Maybe accurate calculations come in v1.1 :D

[Guest 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!

[Guest martin]

Nice to see a spreadsheet being made :D

A couple of problems so far.

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

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 :D I hope they continue working on it.

[Guest 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]

[Guest Confucious]

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

[Guest spyda]

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

[Guest Confucious]

Try http://www.daycounts.com/download.php?op=mydown&did=17

[Guest spyda]

Try http://www.daycounts.com/download.php?op=mydown&did=17

<{POST_SNAPBACK}>

Confucious says...

you the man!

-icky

[Guest 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.

[Guest 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.

[Guest Dr_StrangeTrick]

I am looking forward to the next version.

[Guest 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  :D

[Guest gglaspi]

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

Edited February 7, 2005 by gglaspi

[Guest 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.

Edited January 27, 2005 by Phil Lee

[Guest 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

I'm planning my wedding

Best wishes !!!

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

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

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

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

I'll try to make my own ican

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

Suggestions

........

........

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

:mrgreen:

[Guest 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 :D

[Guest gazzaman28]

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

[Guest TKJ]

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 :D

TKJ

[Guest 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 :D 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..?

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 :D 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..

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

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 :D

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:

=[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 :D )

Then there is the thing that sometimes it calculates wrong :P 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

[Guest gglaspi]

Hello,

There exist a new version of Spreadsheet SP (1.1) with lot of changes :

This version implements following enhancements:

Add functions Sum, Average, Number, Max, Min, Today, Now, Trigonometry.

Function selector

Application icone changed

Possibility to clic on a file to open it

lists the three last opened files

Cell editing activates 123 mode as default

Displays the opened file name in the title bar

This version fixes following bugs:

CSV files with blak lines

Entered value is now displayed correctly in the spreadsheet

"Headers" et "Separators" menus are disabled if no file is opened

Removed the shortcut key for separators

Edited February 7, 2005 by gglaspi

[Guest Phil Lee]

Wow, you've been really busy. I've just installed the update and will load up my latest wedding spreadsheet once I've put it onto the phone. Thanks for your hard work.