Online spreadsheet proggy

Questions about programming languages and debugging
Post Reply
User avatar
Gogeta70
^_^
^_^
Posts: 3275
Joined: 25 Jun 2005, 16:00
18

Online spreadsheet proggy

Post by Gogeta70 »

Hey guys, i got bored and made an online spreadsheet program, can't think of more functions to add to it. Any ideas?

http://g70net.com/excell

:P
¯\_(ツ)_/¯ It works on my machine...

rhysh
Fame ! Where are the chicks?!
Fame ! Where are the chicks?!
Posts: 767
Joined: 15 Nov 2006, 17:00
17
Contact:

Post by rhysh »

thanks,nice!

User avatar
Gogeta70
^_^
^_^
Posts: 3275
Joined: 25 Jun 2005, 16:00
18

Post by Gogeta70 »

You're welcome :)

Can you think of any functionality to add to it?
¯\_(ツ)_/¯ It works on my machine...

User avatar
sternbildchen
Fame ! Where are the chicks?!
Fame ! Where are the chicks?!
Posts: 421
Joined: 26 Apr 2006, 16:00
17
Location: Germany

Post by sternbildchen »

Maybe I just can't find the right command.

But don't you miss things like =A2+A3 or summe(a2:a4). Maybe the results could be displayed before creating the excel file.

User avatar
maboroshi
Dr. Mab
Dr. Mab
Posts: 1624
Joined: 28 Aug 2005, 16:00
18

Good work

Post by maboroshi »

Wow thats really sweet

I like how you can gen excel docs how did you build it is there server side stuff in there?

I am really impressed with this. Although I don't know much about spreadsheets good work :D, otherwise I would give you some advice on features to add

User avatar
Gogeta70
^_^
^_^
Posts: 3275
Joined: 25 Jun 2005, 16:00
18

Post by Gogeta70 »

If this program becomes popular enough (meaning i'll add more features), i'll go ahead and post the source code for you,mab ;)


Note: Will post the code when i'm on my web-server computer

Stern:

Any time you click on a cell, 2 input boxes appear above the spreadsheet that you can put in 2 different cells and it'll add that range of cells, for example
Input 1: b1
Input 2: b5

Result: b1+b2+b3+b4+b5

However, i will be changing that to where you can type "b1-a3+c7+b4*a5" or whatever.
¯\_(ツ)_/¯ It works on my machine...

User avatar
n3rd
Staff Member
Staff Member
Posts: 1474
Joined: 15 Nov 2005, 17:00
18
Location: my own perfect world in ma head :)
Contact:

Post by n3rd »

getta it would be nice to see macro's that can make things alphabeticly, or on rank etc
[img]http://img580.imageshack.us/img580/8009/userbar2k.png[/img]

User avatar
Gogeta70
^_^
^_^
Posts: 3275
Joined: 25 Jun 2005, 16:00
18

Post by Gogeta70 »

Can you explain better, n3rd? I never use excel or any spreadsheet programs, so i'm not sure how their macros work.
¯\_(ツ)_/¯ It works on my machine...

User avatar
computathug
Administrator
Administrator
Posts: 2693
Joined: 29 Mar 2007, 16:00
17
Location: UK
Contact:

Post by computathug »

Think of a macro as a type of excel template. :wink:

When you find yourself repeatedly performing the same actions or tasks in your spreadsheets, it might be time for you to create a macro. A macro is a recording of each command and action you perform to complete a task. Then, whenever you need to carry out that task in your spreadsheets, you just run the macro instead.

Macros can be activate by a couple of keystrokes or by a worksheet button so they are easy to execute, and, provided they were recorded correctly, they will always carry out the same steps in the same order with no chance for operator error.

Although complex macros can be created in Excel using the Macro editor, it also possible to create relatively simple ones using the Excel macro recorder.
hope tis helps :)

Post Reply