From Apache OpenOffice Wiki
Jump to: navigation, search
Documentation caution.png Please note: This is a dead-end page.

This page will never "serve as a source of inspiration for developers and contributors" for 2 reasons:

  • This page is not part of the development cycle i.e. is not the place where feature requests are tracked.
  • This page has no known readers other than the people who express their wishes on it i.e the developers do not read this page.

Where should I submit my wishes for enhancements then?

  1. Log in to openoffice.org.
  2. Do a query in the issue database to be sure that your wish has not already been reported.
  3. Write an issue as ENHANCMENT or FEATURE.

This page has been locked to prevent further edits.

Below is a list of features that are requested by users. There is also, currently, a separate list for cool new FeatureSuggestions.

Calc: Simplified Graph Annotations

  • Excel allows a chart to use "on the fly" data series. Instead of needing to specify a cell for a data series name, for example, you can put in the text. This is also useful when you need to put in goals to measure against. For example, x axis could be ={2005,2010} y could be ={500,500} for a line from 2005 to 2010 indicating a sales goal of 500 units. This way, you can clearly mark if you've met your target. There's no need to fill up a spreadsheet with this.
  • Excel allows a chart to hide items from the legend. If the data series and the linear regression line are the same color, a good audience doesn't need it spelled out what the linear regression is and it can be safely hidden, reducing clutter and increasing readability of the chart.
  • It's currently hard to identify which R^2 factor goes with which regression line. It would be useful to be able to have the text in the color of the regression line, or have the factor go next to the text in the legend, or have the text of the R^2 box specify which series it applies against, or ... You get the idea.

--Chrysrobyn 13:18, 31 August 2010 (UTC)

Advanced Cropping of pics

Currently Openoffice lacks an easy, straightforward and visual way to crop pictures like MS Word 2007 does. Now you have to find the right option and crop it inserting numbers. Moreover, Word does not actually crop the pic, it just shows it cropped. If Openoffice could make it simple to crop the view of pics, with the possibility of actually cropping the pic (thus saving space), it would be extremely useful!

Disable Page Number on First Page Without Style Sheets

It's a convention on academic papers to begin pagination on the second page. Currently there is a workaround using style sheets, but it would be better to have a simple check box to "Disable page number on first page." Thanks.

picture frame in draw

as I use draw kind like a dtp-programm, it would be useful to have a "picture frame" like in scribus to move and resize the picture inside the frame and let flow text around it.

Change colour to grey range when black cartridge are used

Recently I had a printed document with black cartridge and it contains lot of graphs. I noticed that all colours are print as white, so all graphs was unreadable !!!!

So I think this will be great if Openoffice automatically ( with confirmation windows ) change all colours ( only for printing ) with different grey range and maybe with graphics background ( triangle, square, rectangle, rhombus, cross ... ).

This will be very useful if we have a very important report with no colour cartridge ( which happens very often )!

Make sheet STABLE !

For now, Openoffice use ugly bar and on Office one, they appear and disappear as where the pointer is. For example, if we have a numbering at one paragraph, the Bullets and Numbering bar appear ( that I personally hate that, very ugly ) and if we have merged it before with other bar at the top, the sheet move to the bottom a little bit. And when pointer move to an other part of the text, same stuff, the bar disappear and the sheet move a little bit to the top !

Why don't just anchor sheet at the centre ????????????? It's very annoying me because this is like unstable state of this program !

Please, please, please, hear me !

Option to Sync bibliography database with document

I had the following situation lately: I had edited several entries in the bibliography database (biblio.dbf), but without changing the identifier strings. When I created the bibliography index I expected the document to pull the current entries from the biblio.dbf file (via the identifier string). However it did not, but used some older entries that were saved in the document. Now I had to repeat all the changes I made to biblio.dbf for the document. That was not so bad ;-) But since I had split my thesis into multiple parts, with some bibliography entries appearing in several parts, I had to repeat the process even more often. Therefore I suggest the bibliography database to be linked with the document in a way, that such problems be cicrumvented. For example: The user creates one (or more) bibliography database(s), sets which to use for each document (saved in the meta data) and then is able to make changes to biblio.dbf which are mirrored to the document (at the latest) when the bibliography index is created (as long as the identifier string stays the same).


--LifeScientology 12:25, 15 September 2009 (UTC)

Default to only dictionary for new words

When I add a new word to the dictionary, I have to select which dictionary to add it to, even though there is only one. It would make the process less cumbersome if it would default to standard.dic if there is no other dictionary. Thanks. --Spade 09:18, 15 September 2009 (UTC)

Allow to store a password with a database

I'm trying to use a PostgreSQL database to store references (so they can be used at multiple locations, what a concept!), but I don't want OOo to try to prompt for the password (it doesn't even seem able to do that on 3.0.1). There are other ways of securing the database; it is not the job of an office suite to dictate security policies. Plus, at least the Oasis Specification says you can store a database password with a "data pilot" so why not with a regular database? When it's implemented, the file format needs to be documented. Thanks.

Merge wiki and main OOo site password databases

Given that Sun owns MySQL it shouldn't be that big a deal; users should not have to register twice to use all the facilities of "the OpenOffice.org site".

EPUB export

Due to the growing market and availability of ebooks I would like to see an EPUB export feature. Should be not too hard to implement as this is a simple XML/HTML-based format.

I'm writing a book on writing books for the Kindle and the two bummers I'm facing are that anchors tend to be absorbed into headers "<H1><A name="Chapter1"></A>Chapter One</H1>" and that the Table of Contents doesn't work in HTML mode. Hcobb 17:27, 24 January 2010 (UTC)

Improve Notes

I've noticed that Notes in Writer are much nicer now (OO 3.0) with bubble graphics like MS Word. It would be really nice to extend a note to cover a RANGE of text not just one character location. For example, I'd like to use a Note to mark an entire paragraph as needing modification.

Another request: The ability to reply to your own notes, as well as standard hotkeys to reveal/hide notes. Reil 21:47, 3 June 2009 (UTC)
Another request: The ability to set the default font size of notes. Very useful for teaching. --Scroobious 05:26, 8 December 2009 (UTC)

Indirectly associated to the Notes feature, there is the concept of "highliting with a marker". This could be implemented as an instance or mode of the Notes feature. The context is that of being able to save a highliting mask, along with commentary on the highlited excerpt. It would be useful for this functionality to be implemented in such a way that the highliting overlay and commentary would

1) be toggled on/off for show/hide of highliting (or for the more sophisticated use, toggle between 2 different "named" sets of highliting (should we call this functionality "excerpting") for purposes of comparing notes from different reviewers of the document;

2) be extractable and separately storable as a "named" set, for the purposes of leaving the original repository document unmodified; and

3) be a 2-way functionality (load from file & save to file) for all OpenOffice formats and, due to its ubiquitous nature for archival storage, PDF.

The commentary portion of the Notes functionality could be

1) anchored to same page, anchored to another page, or anchored to an indexed notes "bucket" page (akin to bibliographic listings);

2) toggled on/off for show/hide of the commentary (controlled separately from the highliting toggling); and

3) provide navigation from one note to the next, showing the corresponding except in highlited fashion.

While similarities exist between this functionality and the "revision" highliting functionality, the focus is very different and is not intended to be permanently incorporated into a file, put rather a dependent markup. This could be visualized by double-clicking on a .mup file which would include a reference to the archived ODT/PDF file, load up that source document, then apply the markup masking/functionality for reviewing/study. In this fashion, we need never fear the original file being modified (markup mode might be a read-only mode for the original document, with all periodic saves to the .mup work file).

Improve update interface

Allow the removal of specific items from the Updates for extensions dialog.

As it currently stands if one unchecks an item the "Install" button becomes grayed out, leaving the users with only the "Cancel" option. This means that the next time OOo is launched, that the user is again prompted with "Updates to extensions are available" notice which is very annoying. Apple's OS X allows specific updates to be removed from consideration (i.e. not installed, but taken off the list), with users having the option to restore to the list of available updates those items they have previously removed.

Add a multiple clipboard

A multiple clipboard is very convenient while write a long article. (I mean add a multiple copy and paste buffer, like MS Office word).

second that.--Viceroy321 13:49, 3 May 2009 (UTC)

Changing the (display-)order of columns

It is far too complicated (possible at all?) to alter the ordering (I mean display-order eg. A,B,C -> C,A,B) of the columns in calc. This should be an easy to do task! Swapping the data of two columns does work sometimes, but requires creating a new column, cutting, pasting, and deleting of the old column - too complicated and creates problems with macros I assume (?)...

Keep a row or a column visible

Sometimes you need to scan a spreadsheet but need to know what are the values of one row or column, for example because it identifies the information on the columns or rows. Or because you want to check, lets say, the data on rows 5 and 30 with the in the corresponding columns of the other rows.

Of course, you can hide the lines or columns that don't interest to you. But every time you move to another part of the spreadsheet you may need to re-hide the lines or columns.

It would be useful if when we right-click on a row number we had an option to "Keep it visible". A copy of the lines so selected would be kept above all other lines, may be with a different color to stress that they are a copy. These lines would be kept there, regardless were we go in the spreadsheet, making it much easier to compare them with other lines in the spreadsheet. A similar feature could be implemented for the columns.


Search 'Autosave' on your favorite search engine and you will see real writers want it.

It should save every word. Time based systems may lose a few paragraphs.

It may be a resource hog but it should be an option. Just warn the user.

It would definitely give OO and advantage over MS Word. they do not have this feature.

Competitive Parity

  1. Increase/Decrease Font Size proportionally for whole text block.
    • There are two aspects of this. The basic aspect is to have commands that scale fonts for indented lists proportionally. Everything gets bigger or smaller. The other is to use this automatically to decrease all text size proportionally when adding another list item makes the list exceed the text box dimensions.
  2. Insert… Table in Impress
    • This would pop up a dialog to specify rows, columns, width (pixels/percent/auto) and then lay the table as an element of the page. Writer already supports tables like this.
    • This is being addressed as part of the accessibility work in ODF/ODP - Details to be published shortly.

Button to enable/disable all "smart" features

This could be a button, much like and next to the AutoSpellcheck button, which in one click enables/disables all smart features.

I can't say how often I struggle with OpenOffice (or MS Word for that matter) being too smart - doing lists, numbering, applying formatting, creating hyperlinks when all I want is for it to do what I ask it to do - create lists when I select so, create hyperlinks when I tell it to. Sometimes, however it is good to utilize the automatic stuff as you can work with them when you know how they work.

What I propose is a button, much like the spell-check underlining button (which is by default visible in the toolbar) and which enables and disables all these "smart" features - all in one click. It could be called "WritingAids" (as where you can control this settings). It could also be automatically recommended to the user when OpenOffice automatically applies some formatting and the user undoes this, say the user writes a web-address presses space and the hyperlink is created and then the user undoes this thing.

I very much second that. Smart features that (wrongly) second-guess what you do is perhaps the most annoying feature of OO.o--Viceroy321 13:50, 3 May 2009 (UTC)

Creative Commons

Nathan Yergler describes here http://wiki.creativecommons.org/OpenOfficeOrg_Addin, requirements and ideas for embedding Creative Commons license information in ODF documents. Malte Timmermann and Laurent Godard have described on the mailing list how this can be done as a component, perhaps using PyUNO.

Looking for a volunteer!'. Malte & Laurent will help and mentor.

I think there is no reason to restrict that to CC. Make this an open container with several common licenses in there by default, as well as a standardised way to add licenses later.--Viceroy321 13:51, 3 May 2009 (UTC)


Integrate JFree?

Text & Formatting Control

1) When one links to another document, such as through a section, it's fine if another openoffice file; it also works with HTML...but if there is CSS or .js files then these aren't applied or displayed. The advantage, then, of linking is lost; and X/HTML + CSS/.js is incredibly useful for doing things that word-processors and other file formats just don't want to. It's also useful to be able to do markup for one body of text, as well as uniformly controlling the text and its styles, fonts, etc. across many different documents, for online work, as well as then being able to import that through linking and finish formatting for printing and/or book work. Though openoffice has its own styles features, it would be advantageous and very useful to support css and .js so that if those documents change, then the appearance when opened in a linked doc changes.

2) In word processors one can subscript a word, then superscript the next, but cannot place these words below and above one another; I've been trying to figure-out how to do this, and I bet it would be possible with a formatting hack in the XML. It would be extremely welcome to have this ability through a feature in the program, especially for those who work on interlinear texts and such, (and people who do so actually post different questions to the mailing list at times). For now, that's all.

Footnotes 3) I (and others) have the complain that the footnotes generated are inflexible; for instance, one cannot reposition the box to be a column, or at the sides of text (references, annotations, and etc.) at all. This should be possible with the XML underlying the docs, so why not in the program? (forum examples: bible project, http://www.openoffice.org/servlets/ReadMsg?list=discuss&msgNo=55452)

4) Unfortunately widely-known, probably easily-fixed, bugs in OOo seem never to get fixed for being "low" priority; many of which, however, are not. Here's a feature request in just such a position. When footnotes are created OpenOffice doesn't seem to have the capability of putting them on one line, but always starts a new line. But in academia some style manuals DEMAND single lines vs. using half the page for something so stupid. This "little" thing, whether bug, feature, or "request", can stop adoption in its tracks: and universities with a deal on software from Microsoft (and which offer students those deals) aren't opt for OpenOffice when those situations of styles arise; though I might be quite wrong since Word might not even be considered, but instead someone might opt for LaTex, but I'm guessing average Joe doesn't want to do that (for example, I study bio, and don't wish to spend tons of time in XML hacking). (forum examples: 1, 2, etc.)

5) Another footnotes issue is that it appears impossible to insert a footnote inside a frame with text. ?

6) A good suggestion concerning multiple notes by a person is found here: http://www.oooforum.org/forum/viewtopic.phtml?t=17479 from which I excerpt a quote:

"I have a long document with over 200 footnotes (endnotes). Now, I have references in the text body like this: ... by Jorgenson et al. [1,2,3,4,5,6,7] ....

What I would like to have is: ... by Jorgenson et al. [1-7] ... " Infinitelink 11:41, 9 January 2008 (CET)

Formula Entry in Writer

Entering formulas in Writer may well have been ahead of its time and easy compared to alternatives a few years back, as many have claimed, but it is not well behind MS Office. MS Office 2007 has a simple, straightforward GUI for formula entry. Admittedly, the inherent complexities of formula entry still require a modicum of technical attention, but MS Office makes it simple enough that a completely inexperienced user could enter a moderately involved formula within a few minutes without any reference to help files. On the other hand, entering a formula in Writer, as it is currently implemented, requires familiarity with a rather technical entry syntax that is esoteric by comparison.

For myself, this is literally a "deal killer"; I would likely use OpenOffice dominantly or exclusively but for this one missing feature. Being a science major, I have to enter many formulas on a daily basis, often while listening to other important details of a lecture. It is simply not feasible to use OpenOffice in this context.

Liberation Fonts

OpenOffice should install the Liberation Fonts and use them by default, since Arial, Courier and Times New Roman aren't "free" fonts.

Yes. There are quite a number of free fonts out there, and OO.o is a great way of promoting their use. I believe some great fonts currently being freeware could also be made FOSS, if someone from OO.o would approach the authors. Having your font included as a default in a major office package is quite an incentive.--Viceroy321 13:54, 3 May 2009 (UTC)

File Associations

The latest version doesn't seem to support registering OpenOffice as the default program for MS Office documents and whatnot. There should be something in the install screen and preferences for this.

Writer Table Formulas and Code/Macros

I would really like to see table formulas in OpenOffice.org Writer improved so that they support all the same functions as cell formulas in Calc. I would really like to be able to use table formulas in Writer to make "smart" templates that can fill in parts of a document based on other information that has been entered.

An excellent extension of this idea would be better support for macros or code behind a document, similar to what Office supports where there are events and you can write functions to react to them and do useful work on the document. For example, I should be able to put a textbox on a document and an event should be fired when someone has typed in the textbox. Then my code could react to what was typed by changing values elsewhere in the document.

Save embedded objects

In the office I have to struggle with plenty of nasty Microsoft Office documents that tend to have many embedded file (zip files, wireshark traces, pdf files, other Office files...). I can open them whenever they are Office files themselves or plain text, but not otherwise. It would be great to have a right-click-and-save option in OpenOffice to be able to keep those files and open them latter with our chosen application.

text in the margins


well, the image says it all, really. i really would like to be able to add text into the margins, paragraph-wise, in order to give a quick summary of what is written in the paragraph. many books do this and it usually is a big time-saver when searching for a specific item in the text.--Viceroy321 14:04, 3 May 2009 (UTC)

headers/footers outside of page margins

i would really like to see the possibility of entering negative numbers into "page style" > "header" (or "footer") > "left margin" (or "right margin"), so i can make my headers and footers wider than the page itself. my current workaround of just giving all the paragraphs an additional margin is not really the best solution.--Viceroy321 14:04, 3 May 2009 (UTC)

double lines in draw

i want a double (and triple) line in OO.o Draw.--Viceroy321 18:00, 3 May 2009 (UTC)

"inline" paragraphs

i know this sounds a bit weird, but i want a paragraph style that makes it behave as if it wasn't a paragraph. CSS has "display: block;" and "display: inline;" and you can apply this to everything. something like that. Use case: In my table of contents i only want to display the first three levels as separate lines. everything below that, should just be a list "topicA (3), topicB (4), topicC (6), topicD (9),...." --Viceroy321 18:04, 3 May 2009 (UTC)

Ligatures, small caps & subscripts, superscripts

I’d like to request some more advanced font abilities. First: to add support for ligatures (some fonts look weird without using them), you know, fi, fl – everything the font supports. Second: to support true small capitals, if the font contains them. A button (like bold, italic) would be nice. Third: subscripts & superscripts, if scaled from the original numbers, look often too weak. If the font has its own characters for that, ti would be nice to utilize it. --Tomas.keb 12:27, 10 May 2009 (UTC)

Open Recent interface improvement

I would like to see a drop down arrow similar to the one next to the "new document" icon on the toolbar to be added next to the "open document" icon on the toolbar that would bring up a list of all of the files in the "Recent Documents" list. I've seen this on some other applications, and it is a very efficient way of opening recent documents.--Melkevizth 20:38, 18 May 2009 (UTC)

Progress bar while updating the main document

We are working on a OOo Writer main document which includes over 300 sub-documents. The whole document is over 600 pages and 500 graphics. Opening the main document updates the links to all the included documents which takes several minutes, and OOo just show an empty window with a hourglass cursor. Having a nice progress bar would make it much more clear, that OOo Writer is still working.

--Tam 11:37, 27 July 2009 (UTC)

The Mother of All Feature Requests

There should be a way for people to go to openoffice.org and contribute to a fund for the features they want implemented. I think they might have a voting system, but next to the voting buttons there should be a "contribute to this feature" button. That would probably get a lot more contributions. Amulekii 16:10, 14 August 2009 (UTC)

Word count for Impress

OpenOffice Impress should have the same word count functionality as Writer has. It is needed when you translate presentations, for example. (Nowadays, copying text from many separate text boxes to Writer can be very tedious. As far as I know, MS Office has this feature.) --Filipec 09:05, 3 October 2009 (UTC)

Search and replace

The global replace should never scroll to the end of the document. This is important when translating large amounts of text.

Scroll through Autocomplete possibilities in Writer

When I frequently use a long word in various inflections, such as challenged/challenging, I don't want to have autocomplete write challenged, then go back and delete the last two characters, then type 'ing'. It would be great to have a feature where one hotkey scrolls through all words in the list that currently match, and a second hotkey can be set up to send the choice.

Provide full text formatting capabilities such as Strikethrough within cells

Currently one can only apply certain text formatting options e.g. Strikethrough to the entire cell contents. Provide the ability to strikethrough only selected text within a cell.

Personal tools