I am a physics major and I have to preform regression analysis for almost off of my labs. I have been trying to convert some of my friends to Ubuntu and open office, but the problem is Microsoft office has regression as a default option and open office has nothing. For open office to be open to scientists its needs to have more scientific options like regression analysis.
When you generate charts with OpenOffice.org Calc, they have ugly jagged lines.
It would be better to use anti-aliasing to smoothen out the lines to make them more pretty.
Everytime when you are working on a spreadsheet of OOo and you need to choose a custom color for a background of a cell (for example), you must navigate throug a lot of menus like tools > options > colors and substitute an color by your new.
I belive that this operation is a little unproductive.
The Rotate option is grayed out for charts in openoffice.org Calc. I need to rotate it 90 degrees and tried playing with tha data ranges but it's not possible.
At least allow rotations of 90 degrees only, with all text rotated too (the option to rotate text is available but I need the graph to rotate).
When working with X-Y scatter charts in MS Office Excel and pointing the mousse over a point from a chart, a small rectangle with the point coordinates is displayed. And by drag and drop the point one can change these coordinates. Is it possible to make the same for OpenOffice.org Spreadsheet? I really need this option to totally quit MS Windows.
It is already possible to reference a full web page with tables into a Open Office Spreadsheet sheet easily, but it has been hard to reference just a single cell from web into a O.O Spreadsheet cell. In order to make this possible the user must use complex VBA codes.
It would be usefull for people who work with stock market for example.
Since I code very often little PHP-Scripts which I have to print it would be nice to have a Code-Function that formats the marked area the following:
* Monospace font, e.g. Courier New
* Little, e.g. 10 pt
* Number lines - optional, you should be able to set the startnumber
* syntax highlighting like http://www.mediawiki.org/wiki/Extension:SyntaxHighlight_GeSHi/de
* you should be able to choose the language (c++, PHP, Java...)
perhaps you could use the syntax highlighting of kate or gedit