This is the meta issue to track the most annoying bugs in LibreOffice 4.1.x releases. It helps developers to concentrate on bugs that are most critical for users. Also it helps users to be aware of potential problems.
If anyone wants to raise a bug as “most annoying” for the release, please add the ID of that bug to the field “Depends on”, and don’t forget to leave a comment here that explains in a few words why that bug should be privileged.
For details, criteria and further instructions, please see
I am marking this as NEW to get it out of our UNCONFIRMED list :-D Presumably, any bug here will be indeed....confirmed and NEW
Add "Bug 60627 - EDITING: CRASH when 'Format - Bullets and Numbering'"
Bug 38635 - Causes thin gaps to appear in borders, borders look as if they are stitched together and jaggies appear on non-rectangular borders in print. Bug doesn't appear in OpenOffice which would make some users print the documents from OpenOffice to avoid this.
I add "Bug 61187 - CRASH when click 'Add' in EXTENSIONS Manager"
I add "Bug 61332 - FILEOPEN other document via document-hyperlink in LibO3.6-document fails with error message"
Add 60945: 'File -> Save as' shows 'Open' dialog instead of "Save As" dialog => hard to safe files
I nominate bug 61459: several icons are lost, mainly in the Navigator, Styles and Formatting and Formula bar of Calc. Very visible regression.
I add "Bug 61651 - MinGW: Tinderbox @7 does not deliver 4.1 Master builds" together with "Bug 61652 - Tinderbox @6 does not deliver 4.1 Master builds": Master regression survey completely broken for WIN
(Please excuse me for the MAB noise!)
I add "Bug 62478 - CRASH when FILEOPEN databases"
I nominate "Bug 62971 - 3d scene displays 90deg right turned" on this MAB list. Seems like a display bug only, because it is saved correctly.
I nominate "Bug 63547 - Cannot scroll horizontally using trackpad" (Mac OSX bug only, as far we can see) because of the regression 4.0 vs 4.1 and the fact it makes scrolling horizontally using the trackpad useless. You can only scroll in one direction.
I add "Bug 63680 - EDITING: CRASH when click on contents". More or less no editing possible with Writer
I nominate "Bug 62088 - Impress crashes on setting master pages" because of the regression 4.0 vs 4.1.
I add Bug 63840 because it makes LibreOffice unusable for Unity users.
Add bug 62937: It seems to be impossible to create new database
Adding Bug 64584. Asian vertical mode is completely dysfunctional. It was working in 4.0.
Adding bug 64586 - cannot save any text to ppt.
add bug 57079 because this is there sinds 3.3 and becomse worser sinds 4.01 and makes the "contour" feature unusable and documents started in prevsiuos versions un-editable
Added 2 very visible bugs:
bug 64685 : superscript broken, gives subscript instead, even in auto-correction
bug 64751 : Header & footer blue tags empty (no visible text)
I nominate "Bug 64957 - EDITING: letters move around during editing/typing" (Mac OSX) due the fact of the markable regression vs 4.0. For some users this was reproducible with older versions, especially with zoom level != 100%. Now it is always reproducible.
I would like to nominate #64984 as it is IMHO a regression to 4.0.3 ... :(
I nominate "Bug 64995 - Area button in toolbar result in crash". Note: Windows-only so far.
Add 65022: crash when selecting "Format -> Paragraph/Page". It is basic operation.
adding 58317 - UI Pivot Table - Choosing Results to <current sheetname> in More does not set the cell address field enabled
I nominate "Bug 64925 - Crash on display/paste Arabic text"
I nominate bug 65050 : automatic non-breaking space before specific punctuation marks in French texts broken. Regression.
Add bug 65132: Too big font when editing presentation. The text is even harder to read. It is high visible regression.
Bug 65305 - python stuff broken in LO 4.1 on Windows. Wizards and mail merge does not work.
bug 64447, regression wrt to 4.0, "new database wizard" does not do what it shows it will do.
bug 65168: report wizard now creates legacy reports instead of reportbuilder reports. Existing long-standing (from OO.org era) feature is now unavailable.
adding Bug 65241 - FORMATTING: Incorrect formatting text and colors of cells when opening in xlsx-files in Calc
Add Bug 65569 - UI LibreOffice native file dialog does not offer selection list to choose from names that have the same start
Add Bug 53034 - Document properties: Editing-time adding up incomplete
I would like to add "Bug 65653 - EDITING: Base crashes with queries with keyword "LIKE" in GUI-Mode", as it is IMHO a showstopper ... :(
Sorry for the inconvenience
I nominate bug 65501 which make impossible to save a document if "always create a backup copy" option is checked.
add bug 65338 - doesn't retain font settings: after save as and again opening of presentation, font is changed
Good morning :)
I would like the following bugs to nominate as MABs (if you think, they are not adequate, feel free to remove them, but it would be nice, if you could explain your decision ... ;) ):
1. Bug 66009 - Crash, when inserting URL (as Joel has written, it may be an user error, but as it is the default selection, I think it happens more often ... :( ).
2. Bug 66094 - Crash when scrolling to a file with auto-updated links in it
3. Bug 66071 - Crash, when Undo is used too often (not really a crash, what someone told me at first, but more something like "changed document, which will not ask for saving" thingie ... :( )
4. Bug 56392 - Writer: hyphenation is not always used in line break algorithm (as it is a regression to 4.0.4 and making hyphenation unusable with Germanophone version of LO 184.108.40.206 ... :( )
5. Bug 66158 - LO 220.127.116.11 doesn't save path to own certificates (because it is not possible to use own certiicates beside of Firefox ones ... :( ).
Sorry for the inconvenience
I would like to nominate bug 57631 which, in comment #7, Jose L. Domingo on 2013-03-13, has presented his investigations. It seems that this is the same as Bug 59898 and Bug 64598.
As described in Bug 58577, when save a writer file as docx, the text frame is lost (while it still shows up when open with MS OFFICE).
This blocks my work.
I add but 66508 "Coping a chart will make Calc crass.". I think this bug is serious because now charts/copying is useles, slows down work and loses data.
I nominate Bug 66420. It causes data loss and is a very common action (adding words to personal dictionary)
I'd like to nominate bug 52226:
losing images when working with docx without extra backup of the files can have pretty bad consequences.
(This bug exists since 3.5.3 but is still present in 18.104.22.168. I hope this is the right MAB.)
Please don't add a known MAB to more than one version - otherwise it is impossible to see critical new bugs in 4.1. The image issue is a deeply annoying long-standing design issue that needs some funding for the several man weeks it takes to fix.
I nominate Bug 45233 because you cannot edit pps/ppsx Presentations.
I nominate Bug 66478 – hyphenation is broken.
bug 66703: previously in mab4.2, reproduced on 22.214.171.124 (rc2).
bug 66718 - Clipboard API has lost functionality
seems this affects some extensions so moving to MAB
https://bugs.freedesktop.org/show_bug.cgi?id=66655; Function GETPIVOTDATA() always return #REF!
Add the bug #66924: unable to edit presentation master pages
outdated install instructions: README in tarball
I nominate bug 67093 : Title and Heading styles are mixed for several UI languages (FR, PT, Afrikaans, ...)
I added Bug 62729: Cell (range) name lost after FILESAVE after other sheet has been deleted. It courses data loss.
I added bug 67206 - No autocalculation of a cell referenced to a cell, if a column was inserted before -- stops productive work and calculation of cells doesn't work properly.
Adding bug 61544 - Some fields don't fit into Options dialog
Several duplicates (so it must be annoying to several people), leaves parts of options dialog inaccessible.
add 67246 - FILEOPEN General input/output error for particular xls file
Adding bug 37606 - Edit > Select All doesn't work on a document beginning with a table.
It's more than 2 years old. Is it that hard to fix?
removed 37606 since it's reproducibile in 3.3.1, so mab4.1 is not its place.
Adding the bug 67361 - Segmentation fault for Base, on 126.96.36.199, Gentoo, Kernel 3.10.1. I listed the compilation options.
suggesting bug 67099 as MAB, ~700% performance regression vs. 4.0.x in loading ods files
Adding Bug 66864 - By using full screen applications and then restore them, the toolbar disappears in normal view
Adding Bug 65686 - EDITING Data > Validity broken (for list entries at least)
Adding Bug 67489 - EDITING: copied and pasted cells containing formulas are not recalculated
adding Bug 67221 - [FILESAVE] Saving xls file which has cell with formula result #DIV/0! deleted formula, data loss
So it get's on the radar of the appropriate developer ;)
Adding bug 67685: dataloss
Hereby I nominate "Bug 67665 - ODG file forgets styles"
Added bug#66205 - a edit to a basic file results in loss of data. Bibisected & test file available
Nominated bug #67799 - complete loss of functionality for labels with 4.1 - regression
Adding Bug 67815 - DATALOSS: Some cells with hyperlinks in XLS loose content on IMPORT
I nominate the personas Bug 59230 which appears to effect .deb versions of 4.1. Although personas provides no "useful" function in LibO, it is a great emotional aid in personalising LibO and adding company branding. Although I can manually bypass the problem, this would not be in the skill level of the normal user.
Formulas with error result disappear after reload, when file is saved as xls.
Adding bug 67571, data loss of formulas with error result when saving to .xls
Adding Bug 68220 - EDITING: BUG: calc crashes on spell check
I would like to nominate bug 66506. This bug is half fixed, for XLS files, but it's still not fixed for ODS files.
It's an regression introduced in 4.1.
I'm adding it here to keep it on dev radar. If you don't think it should be here please delete it.
I propose Bug 60589 - Cannot copy styles between different files and templates, I continuously have to close LO 4.1 and open LO 3.6 to transfer styles from documents to templates, especially for Calc.
"Writer incorrectly displays non-numbered list dot"
Dot's are seen as unknown character since 4.1 beta 1
Beta 2 sorry
I added bug 68192 "Writer incorrectly displays non-numbered list dot"
Dot's are seen as unknown character since 4.1 beta 2
sorry for the spam
Bug 67534 - FILEOPEN SMB File is Locked By Unknown User message
Bug 67885 - FILESAVE: Files locked after saved on network drive
Note that it seems that bug 67534 also has slipped in 4.0.5
I add Bug 68431 - FILESAVE: Style Font name incompatible with older versions. Users can't force other users to upgrade their installation, just to correctly open their presentation. (Seems like a partially fixed Bug 67665)
added Bug 68756
msvcr100.dll not found after upgrade from 4.1.0 to 4.1.1 on Windows.
already reported by 2 users.
sorry, I meant Bug 68756 not 68576. I'm editing correct numbers.
I add Bug 68771 "Crash on launch on OS X"
4.1.1 doesn't work with some Mac users forcing them to revert to 4.0.5
Added Bug 60270
Crash when click Help bottom after select some functions in formula wizard.
I think the issue is with the new functions in 4 like AVERAGEIF( )
(In reply to comment #83)
> Added Bug 60270
That was meant to be bug 69440 that was already present and got removed from the list instead again.. re-adding.
Added bug 68103 - seems like we have another help issue - draw is linking to impress help that isn't useful for draw making it pretty confusing for users trying to accomplish headers/footers on master documents in draw
SVG-images used as page background are rendered as bitmap / rasterized in LO (188.8.131.52) itself and even in generated PDFs or printouts. This worked fine in v3.4.5.
I nominate two related bugs:
bug 68981 Add dataloss: "thisComponent.store" corrupts the macro library password
bug 68983 "Save As" a document containing a macro library protected by password corrupts the password of the macro library
They meet three criteria (Blocker Bug Definition): data loss, security bug, unusable function
(In reply to comment #86)
> Added https://www.libreoffice.org/bugzilla/show_bug.cgi?id=68927
> SVG-images used as page background are rendered as bitmap / rasterized in LO
> (184.108.40.206) itself and even in generated PDFs or printouts. This worked fine
> in v3.4.5.
I think that is the Bug 62461
adding Bug 69975 - SLIDESHOW: Customized slideshow broken; shows all slides
(In reply to https://bugs.freedesktop.org/show_bug.cgi?id=60270#c88)
I think this is *not* the same bug as in https://bugs.freedesktop.org/show_bug.cgi?id=62461.
There is mentioned that the problem discussed in 62461 works fine in LO v3.6.5.
Tested this bug (68927) with LO v220.127.116.11 (http://downloadarchive.documentfoundation.org/libreoffice/old/18.104.22.168/win/x86/LibO_22.214.171.124_Win_x86_install_multi.msi) and the problem can also be reproduced (image is *still* rasterized). So two conclusions can be made:
1. this bug (68927) must have been reintroduced in a version > 3.4.5
and <= 126.96.36.199
2. the bugs 68927 and 62461 can *not* be the same
When any text around in the cell format around @ format, this text is added to cell content when the file is reloaded.
Added Bug 59918 - FILESAVE: FILEOPEN: save document as docx and reopen result in an freeze/endless loop.
It's an old bug from LO 3.6, but since 4.0 is approaching to EOL, I add it here.
adding bug https://bugs.freedesktop.org/show_bug.cgi?id=69548
Adding Bug 55018, FILESAVE and FILEOPEN: Joined cells in table cause table distortion after save to doc and docx and reopen in LO.
This is an old bug, first reported in Sep 2012, and still reproducable in 188.8.131.52. In my opinion, table distortion = data loss.
adding Bug 70198 - Other: field command "time (fixed)" does not work when used in a writer template file (regressions since 184.108.40.206rc1 IIRC)
I am proposing #67370: automatic hyphenation is not visible in text files exported as tagged PDF. Since PDF/A-1 format forces tagging, PDF/A-1 are affected as well. And PDF/A-1 were supposed to be readable and accessible in long-term future. This will be huge issue for government, business and NGO users when they switch to 4.1.
See comment #10 there for bibisect log.
Windows seems to be not affected by this issue. Mac OS X builds have not been tested.
Let me be 'brave' and add:
Bug 70809 - [EDITING] Selecting with mouse: too fast changing to next/previous page
Bug 70842 - EDITING: Large document with many pictures causes freezing in Writer when scrolling with scroll bar
(In reply to comment #97)
> Let me be 'brave' and add:
Of course, the real brave people will be the dev(s) that, seeing the progress of improvements and cleaning up, will dive into these smelly issues :)
Adding Bug 70815 - EDITING: cell is not updated when referenced cell becomes empty due to sort
Fixed in master, but worth to fix in 4.1. too?
Adding https://bugs.freedesktop.org/show_bug.cgi?id=35217#c8 re: structured outline limitations... and that anchor does point to my comment cherry-picking a relatively solve-able corner case. In legal documents, the ability to comply with court rules is important.
https://bugs.freedesktop.org/show_bug.cgi?id=51168 because doing editing only to discover some list formatting is unexpectedly unchangeable is even more frustrating; I bet the author of Bug 70871 feels the same way about their related problem.
Adding bug 70703: reproducible crash (SEGFAULT) under not-yet-determined conditions when switching focus from one window to the other (LibreOffice Base forms).
please add bug https://bugs.freedesktop.org/show_bug.cgi?id=70933 docx not saving page color
Nominated bug 66988
Regression which makes LibreOffice lose the ability to print some borders. Also seems to affect performance. Simple test document available and bibisect is completed
Seems like drag & drop is freezing up KDE4, also it looks like a regression
This bug seems to be affecting quite a few users from the amount of comments/dupes.
I would like to nominate Bug 68249, a regression in which pasting charts with "data series in rows" from Calc into Writer/Impress results in badly mangled charts. This makes LO 4.1 difficult to use for presenting results. Bug is not present in LO 4.0.
(In reply to comment #105)
> I would like to nominate Bug 68249, a regression in which pasting charts
> with "data series in rows" from Calc into Writer/Impress results in badly
> mangled charts. This makes LO 4.1 difficult to use for presenting results.
> Bug is not present in LO 4.0.
Bug 68249 should be a duplicated of bug 71075, see my comments there, so 68249 should not be on this list.
Bug 71075 is already on MAB4.1 list.
Hi John & suokunlong - thanks for the nominations, John you're right that was a very annoying bug :-)
I add Bug 67401 "Help -> About LibreOffice" Logo not smooth
this issue doesn't affect productivity and is just a matter of aesthetics... however I feel that this ugly about logo could be used against the LibO project to discredit the quality of the project.
I mean, somebody could argue that "LibO comes out with a scrambled about box, would you dare editing your documents with such a buggy software?"
I nominate bug 68876 which is a regression freezing LibreOffice in some case.
I add Bug 62653 - EDITING: Crash on nested table delete (previously titled "Copy Paste Crash"). While the specific situation may not be too common, I experience some crashes with recent LoDev 4.1 that I can't trace, so at least solving this one would rule this out.
adding bug 68600 - properties dialog expands to screen size if long comment is entered
Bug 62461 added because the API does not use a PNG image that is embedded in the ODF file in addition to SVG drawing.
Adding bug 67300, LO shows 2D pie chart as 3D (and shows 3D as 2D) in xls and xlsx.
adding Bug 71248 - when multiple spreadsheets containing VBA macros are opened simultaneously, the last opened document is always considered the "Active" Document/Worksheet/Cell, even if a previous spreadsheet has the focus. Additionally, if the "last opened" document is closed, references to something in the "Active" context fail completely.
Nominated bug 71749 - writer hangs if you open a doc with a table in the footer. This is a recent regression (4.1), the bug has been bibisected.
Nominating Bug "70499 - FILEOPEN Cannot select unprotected cells in XSLX sheet with worksheet protection" as it is an issue with anyone needing to fill in partially protected xlsx forms, which potentially affects an array of different cases.
Bug 66988 was a dupe of bug 68148.
I nominate bug 71667 which is a regression from 4.1.3. It make the functions wizard in Calc less interesting to use. (ATM the bug is marked for version 4.2 but it is reproducible in 220.127.116.11.0+ and I guess in 18.104.22.168 but this version number is not available in BZ).
Best regards. JBF
Adding bug 72278 that has the same cause as bug 71667. Present in 22.214.171.124
Add bug #72072: Text disappear when editing a 90deg Textbox.
This feature worked without problems in LO 4.0.x. So it may prevent users to update to the most actual version.
Bug 72604 - Fax-Wizard - Personal Data are only partial adopted
The wizards are available to start a new fax (etc.) document from scratch. If the personal data are not adopted in the created fax document (and are not in the correct order) the wizard is not useful. This is also a very visible issue, because normal office users will create documents using a wizard.
I nominate "Bug 72614 - Impress hangs on creating new style"
I consider bug 59288 as highly critical. It practically means no conditional formatting until fixed. I found many duplicates, conditional formatting seems really messy in many ways. Evil thinkers consider it "a good example for what goes wrong in LibreOffice development" .
This bug must be fixed.
add Bug 69495 - FORMATTING: Toggling off bold/italic does not turn it off, but instead applies no-bold/no-italic. This messes up any style afterwards that has bold/italic in it (until Clear Direct Formatting is used) ..
Adding bug 72504: one Unix, one cannot anymore open / modify embedded databases on a non-local filesystems.
I nominate bug 72645
Function GETPIVOTDATA does not work as it did upto 4.0.6
I nominate Bug 72645
GETPIVOTDATA does not work as it did up to 4.0.6
Bug 67104 - Default value of "Show cell grid lines" checkbox on sidebar. Highly visible new feature semi-broken, several duplicates, seems annoying enough.
Bug 68806 - SIDEBAR: Wrong Paragraph spacing values after opening Properties deck. Again, new and visible feature half-broken, making the sidebar pretty annoying to use for me.
Add Bug 73095 - Writer's UI crashes when scrolling pages if formatting marks are visible: the work of Writer is broken in Windows XP within a single release (between 126.96.36.199 and 188.8.131.52.0+).
Added bug 73616 - very simple test document is locking LibreOffice on multiple platforms. Bibisected and confirmed it's a regression that came in somewhere in the early days of 4.0
Removing developer list for bulk change.
readding after bulk change.
Add bug 73805 Crash when writing into a section with columns, with highest priority - Sophie
Add bug 69244
Calc required Cltr+Shift+F9 in some conditions => some formula are recalculated, but not all, and user doesn't know it
Bug - 67712; FORMCONTROLS: anchored to cell but changes position after reopening
There is regression and Data Loss
I nominate bug 74493 : regression and dataloss
adding Bug 72284 - FILESAVE: Crashes when trying to save a particular docx file
Added Bug 52226 - "FILESAVE Images in .docx and .xlsx files show "Read-Error", probably corrupted by auto-save"
Moved from MAB 4.0 since 4.0 reached EOL.
Pretty big show-stopper as it seriously impedes collaborating with colleagues who decide to work with a docx file.
Has been a MAB since 3.6.
Added bug 74557 file corruption on saving as xls - Sophie
Continuing the cleaning of mab4.0. Only bugs not yet reported reproducible in 4.1 or 4.2 should remain.
Nominating Bug 56394
It's almost impossible to open that specifix XLSX file.
Bug 61840 - FORMATTING: Formating numbers in Data Pilot table does not work anymore (regression)
Nominating this bug, because it is a regression (to 4.0.0.x and still here in 184.108.40.206) and because it is really annoying to do the formating for each and every data pilot table / pivot table once and once again after the data is refreshed.
(In reply to comment #142)
> Bug 61840 - FORMATTING: Formating numbers in Data Pilot table does not work
> anymore (regression)
> Nominating this bug, because it is a regression (to 4.0.0.x and still here
> in 220.127.116.11) and because it is really annoying to do the formating for each
> and every data pilot table / pivot table once and once again after the data
> is refreshed.
FWIW, this never worked, so not a regression. If it ever appeared to have worked before, it was a fluke.
added bug 71478, comments lost on the page that is copied to another one. Sophie
Nominated bug 37223 - Impossible to copy just values from spreadsheet into a table in Writer - inherited by OOo but quite annoying.
a couple dupes and a few users involved. Plus I guess it was reported during OOo days and had 100+ "votes" on their infra.
Nomintated bug 75648 - results of simple formulas are being quasi lost with xlsx but if you just edit the formula by removing the last character ')' and then put the character back the formula works as expected.
Bug 71278 - UI mouse pointer disappears during presentation and does not come back after exiting presentation
Nominating this bug, because it is a regression (to 4.0 series and still in 4.2) and because it is really annoying, I have to restart LibreOffice in order to use my mouse again.
Nominating Bug 51819 - Password-protected documents saved unencrypted for auto-recovery
Bug is serious security issue. Regression apparently appeared in 18.104.22.168 and is assumed to be still present in the 4.2 branch.
Hereby I nominate "Bug 64490 - LibreOffice Writer text highligthing is not compatible with Microsoft Word DOC and DOCX (highlighting transforms to background color)"
(In reply to comment #149)
> Hereby I nominate "Bug 64490 - LibreOffice Writer text highligthing is not
> compatible with Microsoft Word DOC and DOCX (highlighting transforms to
> background color)"
Seconded. It's the most important problem in exchanging document with my collegues at work.
I nominate "Bug 63087 - Detective "Trace Precedents" or "Trace Dependents" pointing to a different tab does not provide reference cells".
Though the bug or rather missing feature is old I consider it to be very important. I find it impracticable to understand complex spreadsheets without a "detective", which works across worksheets. Therefore, I consider MS Excel to be necessary for understanding a complex spreadsheet, even if one works primarily with LibreOffice Calc.
Removed bug 63087 - was an enhancement request that does not belong on the list.
(In reply to comment #152)
> Removed bug 63087 - was an enhancement request that does not belong on the
Sample ods file crash at opening.
please do not add new bugs here. the 4.1.x branch won't probably have other release after 4.1.6.
new annoying bugs should be posted to the mab4.2 or mab4.3 lists.
existing mab4.1 which are still reproducible in 4.2.x branch can be moved to the mab4.2 list.
Ok. all existing mab4.1 have been moved to the mab4.2 list.
marking this as CLOSED FIXED
using spareadsheet, when i try to add new line in Cell ... means writing more than one line in a cell, save changes, close the file and re-open it, cell content appears all in single line. new line character is lost. i'm saving my file as .xlsx file. (MS Excel 2007/20010 etc. ) format.
closing MAB again
please DO NOT reopen this bug
The MAB docs on the wiki have been updated to reflect the new
Priority-based system for categorizing bugs:
The old MAB tracker bugs (mab4.3, mab4.4, etc.) will remain in
Bugzilla for historical reference, but should be ignored for current
FINAL mab4.1 STATS
fixed bugs -> 137
open bugs -> 0