spreadsheets

As some of you may know, I tutor students in finance. I'm also a huge comic book fan, so when a student came in with a problem involving Scrooge McDuck, I was thrilled. In one of the most famous Scrooge stories ever, Back to the Yukon (rated the #1 Donald Duck story of all time at Inducks)...

Arg! I am fairly sure this can be done, but unable to figure out quite how to do it. I know that you can embed a google doc/spreadsheet on your website--that part is easy What I would *like* to do is have the spreadsheet retain the ability to be sorted by column. (I want to do this mainly...

Downloaded Open Office so I could use the spreadsheet to graph some data. Open my space-delimited text data file in it, did some graphs. So far so good. It then crashed. Re-started it. Now I go to open the exact same .txt file from within Calc (within Calc, keep in mind) and it is happy to...

I have a few hundred cells with formulas in them referencing other tabs in the same worksheet. All of them use "relative" cell references rather than "absolute". I need to be able to copy/paste these several times without the formulas changing, so I need the formulas to have absolute cell...

I've got a spreadsheet on Google docs, and my experience with spreadsheets is very limited. There's a date column, with most dates like this 2009-09-07but also a bunch like this 2009-09-07-A01 2009-09-07-A02I want to lose the suffixes, and just keep the dates (yyyy-mm-dd). There are a lot of...

I've written a spreadsheet in OpenOffice that lists the possible results of rolling 2 six sided dice after adding any number. roll It also lists the possible results of a roll of another set of 2 six sided dice after adding any number. The numbers added need not be the same, and usually aren't...

I currently have the entire OOo suite installed for the sole reason that i need to make a spreadsheet and send it each day. I really see no reason why i couldn't do this in a simple terminal/curses program. I've looked a bit, but i can't find any that support xls, nor any that had (good/any)...

i'm trying to make a simple spreadsheet where in one cell i can type in the time an employee starts, in another cell the time they finish and have the hours worked pop up in a third cell (automatically deducting one half hour for lunch break) example. cell 1a, i type in 6:50...