Ubuntu QA:
BlogBrainstormPackage status
Log in
Ubuntu QA
OpenOffice.org Spreadsheet
Idea sandbox Idea sandbox
Popular ideas Popular ideas
Ideas in development Ideas in development
Implemented ideas Implemented ideas

Popular ideas Here are the most popular ideas ever about OpenOffice.org Spreadsheet.

Regression Analysis  
Written by jtso8 the 23 Mar 10 at 00:46. New
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.
261
votes
up equal down
Solution #1: Add Regression Anaylsis to Open Office Spreadsheet
Written by jtso8 the 23 Mar 10 at 00:46.
Add regression analysis to to Open Office Spreadsheet or at least linear regression.
-152
votes
up equal down
Solution #2: Make a plugin to easily install Office in linux
Written by Zach the 23 Mar 10 at 04:00.
Make a simple wine plugin just for office.

See the 12 comments or propose a solution >>

Antialiased charts in OpenOffice  
Written by Eldmannen the 28 Jul 08 at 14:33. New
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.

Look at the ugly jagged blue lines.
* http://upload.wikimedia.org/wikipedia/commons/b/b6/Dropout.png
183
votes
up equal down
Solution #1: Auto-generated solution of idea #11588
Written by Eldmannen the 28 Jul 08 at 14:33.
Ubuntu Brainstorm was updated in January 2009. Since the idea #11588 was submitted before this update, its rationale and solution are not separated. Please vote accordingly, and if you have the necessary rights, please separate the rationale from the solution. Thanks!

See the 5 comments or propose a solution >>

The dificulty to choose a custom background color to a cell  
Written by luiz.hey the 29 Apr 10 at 15:10. New
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.
59
votes
up equal down
Solution #1: Put an "Add Custom Color" button in the color chooser
Written by luiz.hey the 29 Apr 10 at 15:10.
when you open the color chooser box, maybe there could be a button that provide an custom color choose funcionality.



Add a comment or propose a solution >>

Allow rotation of charts in openoffice.org Calc  
Written by davagui the 22 Oct 08 at 23:06. New
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).
25
votes
up equal down
Solution #1: Auto-generated solution of idea #14712
Written by davagui the 22 Oct 08 at 23:06.
Ubuntu Brainstorm was updated in January 2009. Since the idea #14712 was submitted before this update, its rationale and solution are not separated. Please vote accordingly, and if you have the necessary rights, please separate the rationale from the solution. Thanks!

See the 3 comments or propose a solution >>

OpenOffice.org Spreadsheet Significant Digits  
Written by andruk the 1 Apr 08 at 08:41. New
You have to manually edit each cell to get it to use the correct number of significant digits.
24
votes
up equal down
Solution #1: OO.o Calc should keep track (Original solution from pre-January 2009 idea)
Written by andruk the 1 Apr 08 at 08:41.
It would be really cool if you could set how many significant digits for one cell, and then Spreadsheet would keep the correct number of significant digits for all calculations done with those cells. It would be fairly easy to do too.

See the 2 comments or propose a solution >>

Chart coordinates in OpenOffice.org Spreadsheet  
Written by befana the 3 Oct 08 at 11:02. New
Hi!

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.
17
votes
up equal down
Solution #1: Auto-generated solution of idea #14012
Written by befana the 3 Oct 08 at 11:02.
Ubuntu Brainstorm was updated in January 2009. Since the idea #14012 was submitted before this update, its rationale and solution are not separated. Please vote accordingly, and if you have the necessary rights, please separate the rationale from the solution. Thanks!

Add a comment or propose a solution >>

Reference in Cells  
Written by sandrex the 15 May 10 at 02:22. New
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.
1
votes
up equal down
Solution #1: Create a selector of web cells to reference
Written by sandrex the 15 May 10 at 02:22.
Create a new tool.
Enabing this tool the user whould later bring to front the web page and "on mouse over" a red line would indicate that there is a cell to reference, missing just one click to select.

Then, the Spreadsheet cell would get the data of the web cell easily.
5
votes
up equal down
Solution #2: Enhance OpenOffice
Written by Darwin Survivor the 18 May 10 at 11:45.
Instead of trying to add "selectors" to each web browser, why not give OpenOffice the ability to decode tables on its own?

See the 1 comments or propose a solution >>

OpenOffice inverse-squared regression  
Written by andruk the 18 Mar 08 at 08:58. New
OpenOffice.org Calc doesn't have a lot of scientifically useful regression curves (also known as curve fits, linear and non-linear models, etc.).
2
votes
up equal down
Solution #1: Inverse-squared regression (Original solution from pre-January 2009 idea)
Written by andruk the 18 Mar 08 at 08:58.
I would like to see a regression curve for OpenOffice that is 1/r^2, for those of us that have to work with intensities.

Edit: For clarification, a regression curve is a curve that is fitted to a set of data, using a variety of techniques and formulas. The final result can be of the form a y=e^x (exponential), y=ln(x) (logarithmic), y=x^n+x^(n-1)+x^(n-2)+... (power), or y=a*x+b (linear) (n, a, and b are all constants). For more information about regression curves, see here: http://en.wikipedia.org/wiki/Curve_fitting

What I would like to see (and this may not be for the Ubuntu folks, more for the OpenOffice folks) is a regression curve of the form y=a/(x^2), so I can fit intensity data from experiments that I do (I'm a student).

For further clarification, this regression has nothing to do with software regressions, or anything to do with computer screen intensity, or the radius of anything onscreen (unless I am required to do an experiment with computer screens).

See the 4 comments or propose a solution >>

OpenOffice - Highlight code like gedit or kate  
Written by moose the 15 Nov 08 at 23:25. New
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
-8
votes
up equal down
Solution #1: Auto-generated solution of idea #15666
Written by moose the 15 Nov 08 at 23:25.
Ubuntu Brainstorm was updated in January 2009. Since the idea #15666 was submitted before this update, its rationale and solution are not separated. Please vote accordingly, and if you have the necessary rights, please separate the rationale from the solution. Thanks!
2
votes
up equal down
Solution #2: Bundle COOoder extension with open-office or offer it in the repos
Written by diaa the 23 Mar 09 at 23:48.
COOoder is an OOo extension that makes it easier to syntax highlight text in OOo.

If it comes pre-installed or is offered through the repos this will solve this issue.

See the 7 comments or propose a solution >>