User:Lendo/Usability

Usability Issues at Daily Work with OpenOffice.org

I'm working with (and spreading the word about) OpenOffice.org at work and found some issues that make it harder to work with the applications as it should be. I talked with Frank Loehmann from the User Experience Team a few times - thank you for your sympathetic ear, Frank! Also I reported most of the issues at IssueZilla. I hope this wiki page will call more attention to these issues and maybe some developers will fix it in the future.

If you also are affected by an issue mentioned here, please vote for it! Go to the issue page, log in and click at "Vote for this issue". Go to the issue in your "Show votes" page, enter "1" in the votes column and click "Submit" at the bottom of the page. Thanks for your vote!

PS: "Serious" means that this issue breaks or disrupts the normal user workflow.

List of Issues

Serious Usability Issues

Issue list of all serious usability issues

• Issue 3545 Easier Cropping and rotating of images (application: Writer)
• Issue 10865 Moving/Copying - Single-Cell using click-n-drag (application: Calc)
• Issue 19291 Split Windows for single document (application: Writer)
• Issue 42120 Show quantity of selected cells in the "Name Box" of the Formula Bar (application: Calc)
• Issue 49754 loading paragraph styles removes outline numbering (FIXED 3.1)
• Issue 85076 Calc won't print/preview documents containing only cell borders (application: Calc, maybe patch for 3.3)
• Issue 88714 Find & Replace: keep the "More Options" dialog open when item is selected (application: Calc, my issue, planned for 3.3)
• Issue 93282 Table cell number format: user is misinformed (application: Writer)
• Issue 93938 Calc loses selected range in a sheet when going to another sheet (application: Calc, my issue)
• Issue 94285 Writer crashes when applying template page break styles to document (FIXED 3.2)
• Issue 94809 Copying column to another with different width doesn't reposition pictures correctly (application: Calc, my issue)
• Issue 97151 Space between paragraphs filled with paragraph background color (application: Writer, my issue)
• Issue 98283 Unwanted page break at the beginning of every sub-document (Heading 1 inserts an automatic page break in Master Document spuriously) (application: Writer, my issue)
• Issue 99971 New file not in front window (application: all) (FIXED 3.2)
• Issue 100178 Multiple headings with same name are ignored in Table of Contents (application: Writer, my issue) (FIXED 3.2)
• Issue 100262 "Restart Numbering" on first list item not preserved (application: Writer, my issue, planned for 3.3)
• Issue 100263 Highlight more than 32 cells in Calc (application: Calc, my issue)
• Issue 102359 "Document in Use" dialog is not brought in foreground when Office window(s) is minimized (application: all) (FIXED 3.2)
• Issue 102618 Table - Autoformat: Sum row should be optional (application: Writer, my issue)

Annoying Jump Issues

• Issue 6709 Refreshing an index jumps (application: Writer)
• Issue 22453 Jump to cursor when scrolling with the mouse wheel after having clicked menu Format or Insert (application: Writer) (FIXED 3.2)
• Issue 25483 Text jumping during vertical scrolling drives me nuts (application: Writer)
• Issue 25487 When using highlighting displayed page jumps up (application: Writer)
• Issue 31830 Jumping when selecting image (application: Writer)
• Issue 34425 Spellchecker always jumps back to cursor position where it was started (application: Writer)
• Issue 48193 Editing document with pictures and frames is jumpy (application: Writer)
• Issue 54478 View jumps when a point is added (application: Writer)

• Issue 60325 Page jumps when Edit/Changes/Record is enabled/disabled (application: Writer)
• Issue 69966 Cursor jumps to the next cell if DEL key is entered inside empty cell of table (application: Writer)
• Issue 88413 Deleting graphics makes display jump (application: Writer)
• Issue 93536 Page anchored frame jumps to top of page when moved (application: Writer)
• Issue 103790 Jump to cursor ON clicking the menu Format or insert (application: Writer) (FIXED 3.2)
• Issue 103835 Jump to cursor on Autosave (application: Writer) (FIXED 3.2)
• Issue 103836 Jump to cursor on Save (application: Writer) (FIXED 3.2)
• Issue 103838 Jump to cursor on closing the language bar pop-up menu (application: Writer) (FIXED 3.3)
• Issue 103839 Jump to cursor on switching between OOo documents (application: Writer) (FIXED 3.2)
• Issue 105474 View jumps up to the top of the comment/note if it's larger than the screen height (application: Writer, my issue)
• Issue 106906 Jump to cursor when saving as Word document (application: Writer, planned for 3.3)

Non-serious Usability Issues

• Issue 15530 Default filename for PDF export (application: all)
• Issue 18771 MSInteroperability-18: watermarks (application: Writer)
• Issue 20073 Q-PCD Enhance usability of the OpenOffice.org Template Manager (application: Writer)
• Issue 22405 An easy way to create watermarks with text (application: Writer)
• Issue 56388 AutoCaption feature does not support all type of formating (Position of caption) (application: Writer)
• Issue 64484 Option to remove all hard formatting controls from the UI (application: all, my issue)
• Issue 80664 Implement Language Control for Draw/Impress Status Bar (application: Draw, Impress)
• Issue 80665 Implement Language Control for Calc Status Bar (application: Calc)
• Issue 88716 Page Up and Page Down doesn't scroll a full page the first time (application: Writer, my issue)
• Issue 91001 Side-by-side view with synchronous scrolling (application: Writer, my issue)
• Issue 92154 show accept/reject comments as notes (application: Writer)
• Issue 95647 Allow to start presentation in fullscreen and window modes from ActiveX control (application: Impress)
• Issue 97364 Page numbering should not be touched from paragraph style in Indexes (application: Writer, my issue)
• Issue 99210 Font color palette reverts back to default color after using a non-default font color (application: all)
• Issue 99536 Scaling factor slider lacks displaying factor number (application: Calc, my issue)
• Issue 99955 de: Update warning should not have a scrollbar (FIXED 3.2)
• Issue 100404 A proper color palette/picker for usage in the entire suite (application: all)
• Issue 101218 File name should be visible in new password dialog (application: all, my issue)
• Issue 101479 Confusing error message when printing transparent objects (application: Writer)

Other Serious Issues

• Issue 32141 manual page break with style change in masterdocument ignored (application: Writer)
• Issue 73060 Multple Data Sources in one Database File (application: Base)

Other Non-serious Issues

• Issue 10459 Template Association (apply templates to existing documents) (application: Writer)
• Issue 12989 Allow Page Templates to be linked (application: Writer)
• Issue 52783 change templates for a document (application: Writer)
• Issue 65055 Keep small bullets as default in old documents (like sxw) (application: Writer, my issue)
• Issue 90173 Icons of the new Startcenter should be grayed out when loading a document (application: all, my issue)
• Issue 99963 Wrap with text in line missing (application: Writer, my issue)

There are many other issues, especially those with more than 50 votes.

Some Serious Usability Issues in Detail

Issue 3545 Easier Cropping and rotating of images (application: Writer)

It's very common that people want to edit images that they fit into the page structure. My collegues do that every day (with MS Word). Copying the image into Draw, cropping it, and copying it back to Writer is not a solution! The solution in Draw should be available in Writer too. I read in the Issue that OD is working on that maybe for OOo 3.2.

Issue 10865 Moving/Copying - Single-Cell using click-n-drag (application: Calc)

The current behavior of moving/copying one cell using the mouse is not intuitive (click on a cell, hold the mouse button and move the cursor to another cell, go back to the first cell and loose the mouse button; then move the cell to another position in the sheet). Some people said that patents hold back the implementation of a solution for this issue. Is there no workaround for this patent(s) possible?

Issue 19291 Split Windows for single document (application: Writer)

At the moment, to edit a long document while referring to another part of the same document which is in another page can only be done through opening another Windows. This is less than satisfactory. A split screen is needed for efficiency and usability. This issue received 160+ votes and yet not implemented since version 1.

Issue 42120 Show quantity of selected cells in the "Name Box" of the Formula Bar AKA number of rows and columns showed for selections (application: Calc)

There is no information in Calc how many rows and columns are selected. For example, if you have selected cells A4:A31 it would be useful to show the number of selected cells: 28. So you must not count manually.

Suggestion: Extend the "Name Box" of the Formula Bar with quantity information when more than one cell is selected. If the cells A4:A31 are selected, the Name Box should show "A4:A31 (28)". If the cells B4:E31 are selected, the Name Box should show "B4:E31 (28x4)".

Quantity of selected cells in the "Name Box" of the Formula Bar in a competitor program (German version)

Issue 85076 Calc won't print/preview documents containing only cell borders (application: Calc)

Very bad impact of a modification of the Calc print preview long time ago.

Issue 88714 Find & Replace: keep the "More Options" dialog open when item is selected (application: Calc)

If you use the "Find & Replace" dialog and if you select an item of "More Options" (backwards, regular expressions, etc.), next time you open the "F&R" dialog the "More Options" part will be not shown - but the item will be still selected.

It is not visible to the user that the "More Options" item is still selected, so it can (and will) be forgotten. Therefore the user can't find what s/he wants and doesn't know why.

Suggestion: When opening the "Find & Replace" dialog, keep the whole dialog open as long as an item of the "More Options" part is selected.

Issue 93938 Calc loses selected range in a sheet when going to another sheet (application: Calc)

When you have two sheets in a spreadsheet document and

• you select a range of cells (e.g. A1:B3) in sheet 1 and
• then you are going to sheet 2 and
• back to sheet 1,

the selected cell range is lost and only the last selected cell of the range (B3) is selected.

Expected: The selected range shouldn't be lost. There are a plenty of use cases where you need to look to another sheet during an operation with selected cell ranges in the first sheet.

For example, it is annoying to lose the selection of dozens of cells in sheet 1 only because you have to varify the selection with information in sheet 2 - before you have finished the selection and before you have executed an operation, e.g. deleting or cell formatting.

Issue 94809 Copying column to another with different width doesn't reposition pictures correctly (application: Calc)

In a Calc sheet, I have columns with 2 different widths. Each column has a picture (anchored to the cell), either a wide or a strait one. If I delete a wide column with its picture and then I copy a small column and insert this into the empty wide column, the width of the column will be corrected. Because of the copied strait column, the wide column become strait too. So far, so good.

But the picture of the wide column and all following columns won't be repositioned to the right new position. I will attach a picture to demonstrate what I mean. Now, you have to correct the position of the pictures manually and that's not satisfying.

Expected behavior: Inserting a column with different width as the existing column should reposition all following pictures so that the distance to their cell borders will be the same as before. The difference of the width between the wide and the strait column should also be applied to the picture.

Copying column C to column E (both has different widths) doesn't reposition pictures in subsequent columns correctly

Issue 97151 Space between paragraphs filled with paragraph background color (application: Writer)

If you have several headings with the same paragraph background color, then the space between the headings will be filled with the paragraph background color of these headings.

See A) in the attached picture with 2 headings (level 2+3).

This bug doesn't occur when inserting a new paragraph in another style (e.g. Default - see B) in the picture) or after changing the background color of one heading (see C) in the picture). Why is the "spacing" not filled when the paragraphs has different colors? This is definitely a bug and not a feature. It looks not "right".

Expected behavior: Space between headings shouldn't be filled with color anytime.

Space between paragraphs filled with paragraph background color

Issue 100262 "Restart Numbering" on first list item not preserved (application: Writer)

The first numbered list of a document doesn't keep "Restart Numbering" after reopening if it was set with right-click and context menu only. It only keeps the setting using "Paragraph... > Outline & Numbering > Numbering" with "Restart at this paragraph" and "Start with 1".

Normally it is not necessary that this setting is preserved for the first numbered list in a document. But:

• If this document is part of a Master Document, then the false setting results in confusing/false numbering if you don't use the (more complicated) paragraph dialog.
• User setting should always be preserved after saving the document - and not get lost.

MRU->OD: a "Restart numbering" on the first paragraph of a list will only be saved when a new "start with" number has been assigned. This can be of interest for Master-/Sub-documents using list styles and outlines.

Issue 100263 Highlight more than 32 cells in Calc (application: Calc)

Calc only shows a maximum of 32 with color highlighted cells if they are part of an arithmetic operation.

See the attached spreadsheet for an example where cells B3-B30 and C3-C30 are selected - but only the first 32 cells are highlighted with color.

How can users see which cells are selected when they are not highlighted?

Possible solution: Repeat the coloring of the first 32 cells to the second 32 cells, to the third 32 cells, and so on ...

Calc don't highlight more than 32 cells

Issue 102618 Table - Autoformat: Sum row should be optional (application: Writer)

As ES summarized: "the goal here is to get a table formatted with rows alterning their colors throughout the table AND including the last row."

Most times I don't need a sum row. The problem now is that you can not configure the Autoformat feature not to insert a "sum row" color in the last row of the table. In a table with e.g. 6 rows (1 header row, 5 content rows) the last 2 rows get the same color but I don't want this.

It should be possible

• to save a table color sheme without a sum (or/and header) row in Autoformat and
• to assign a table color sheme to an existing table without a sum (or/and header) row - the simplest way would be checkboxes in the area of additional formattings (in German you can open this with click at "Zusätze" in the Autoformat window).

Table formatting should alternate the colors of its rows throughout the table AND should include the last row (as an option). This picture shows the actual imperfect behavior in the last 2 rows.

Some Non-serious Usability Issues in Detail

Issue 88716 Page Up and Page Down doesn't scroll a full page the first time (application: Writer)

Scrolling up and down with the button Page Up or Page Down works only the half way in the first time. Any further Page Up and Page Down correctly scrolls a whole page.

This issue occurs in Writer when viewing with (more or less) 100% zoom factor or when viewing an entire page and then clicking Page Up or Page Down. Only the normal view is affected, not the page preview.

It's annoying to have the half first and the half second page at screen and to adjust that manually to see a full next page.

Suggestion: Page Up or Page Down should ensure full page scrolling instead of half page scrolling (always).

CLOTH: confirming - the view shifts because the page up/down moves the cursor, and he page is displayed as if you would move the cursor one page up/down.

If you only care about moving the view, you can use the page up/down button in the navigator (either the buttons in the mini-navigator, the ones at the bottom of the vertical scrollbar), or the controls in the big navigator.

Page Up and Page Down doesn't scroll a full page the first time

Issue 97364 Page numbering should not be touched from paragraph style in Indexes (application: Writer)

If the paragraph style of an Index (e.g. Contents 1-10) is capitalized, then the page numbers become capitalized too. See attached picture.

Expected behavior: Page numbers (created with Page Layout Settings) should not be touched from paragraph style font effects (capitals, lower case, title, small capitals) of Indexes.

MRU wrote: An exception has to be implemented, which ignores the character effect for page number characters in TOCs.

Page numbering should not be touched from paragraph style in Indexes

Issue 99536 Scaling factor slider lacks displaying factor number (application: Calc)

The new scaling factor slider in Calc page preview is very handy but lacks displaying the current scaling factor as a number. If you want to know the concrete scaling factor you have to go to Format Page > Sheet > Scale > Scaling Factor.

The zoom factor is shown next to the zoom slider in the status bar. Why shouldn't the scaling factor be shown next to the scaling factor slider in page preview?

Maybe a double-click on the scaling factor (number) should open the "Sheet" tab in the "Format Page" dialog like double clicking on the zoom factor opens the "Zoom & View Layout" dialog.

Some Other Non-serious Issues in Detail

Issue 99963 Wrap with text in line missing (application: Writer)

Sometimes it is useful to use a wrap setting "text in line" (known from a competitor program) for frames/pictures within a text paragraph.

Wrap text in line behaves as "none wrap" but the text begins instantly at the bottom right of the frame/picture - and not entirely below the frame/picture.

I will attach a text document with 2 test cases of this feature to see a benefit for "real world" usage.

• Document with 2 test cases for this new wrap option

"Wrap with text in line" as a new wrap option in OpenOffice.org