thanks for the suggestion i just installed it (macos). it solved problem #2, I'll have to wait and see what happens with #1 and #3. I like it but it's like going to a new grocery store and everything is in a different place than i am used to thanks!
Glad you liked it! For charts in particular, I find gnumeric to be more solid than any other spreadsheet software I've tried (including Excel)—the charts are more stable and more configurable, and there are options for more of them (e.g. histograms, which are something I frequently want and Excel just doesn't support, or at least didn't used to). Downside: once you've got a spreadsheet with really informative charts, it's sometimes hard to share, because saving it as .xlsx breaks some of them. :(
Oh, another nifty feature of gnumeric: if you save it in its uncompressed format, it's literally .xml (good both for version control and for scripting certain kinds of things)