[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #12 from Albrecht Müller albrecht.muel...@astrail.de --- Your remark gave me a hint where to look for the language settings. Set the language to German == hyphenation worked. Therefore I think the issue is not in the functionality itself but in the user interface. To illustrate this here comes a short story describing my user experience: I dont use Calc on a regular basis, had some numbers to calculate and thought, the best way to this is to create a litte spreadsheet. I needed some documentation which did not fit in a cell, so I found the word wrap and hyphenation features. Word wrap worked, but hyphenation did not. Hyphenation depends on the language, therefore something may be wrong with the language settings. So I looked into the extras - language menu. It is roughly the same as the corresponding menu of the Writer component. The main difference: the essential part, that allows you to choose a language, is missing. So I cannot set the language, all language dependent features are useless. I gave up and did a manual hyphenation. After having entered the necessary calculations I had to enter a few of the results by hand into a program running on another machine. To make sure I copied the data correctly I did some calculation by hand using the numbers I had just entered. The results did not match. After some double checking of calculations and numbers I was sure: The numbers I got from Calc were incorrect. Toggling autocalc or pressing F9 did not help. Eventually I found a way to correct the wrong values by doing irrelevant changes to the formulas. While doing so I tried the undo function. Result: Undoing the changes did not restore the previous values. Summary: Hyphenation does not work, they forgot the essential part in the language settings menu, calculations are wrong and the undo function does not work. I detected all this in a single simple spreadsheet - what a broken program! Thanks to your help I know now how to deal with these issues. I also have an easy explanation why the two spreadsheeds behave differently: If you create a spreadsheet using the Windows Explorer you get one where the language of all cells is set to None. Therefore hyphenation does not work. If Calc creates a new spreadsheet it it seems to use the language of the current location, in my case, German. Therefore hyphenation works. It took me hours to reach this point. Proper feedback from the user interface could render this to a matter of seconds: 1) When I turn hyphenation on I expect to see hyphenation. There may be sound reasons why this cannot work as expected, e.g. because the language setting does not support hyphenation. In this case the user interface should give some feedback that explains the cause of the problem (Your language setting 'None' does not support hyphenation.) and provides some hints what to do about (You can change the language setting ... there ...). 2) If possible, the user interfaces of the different components of LibreOffice (Writer, Calc etc.) should work the same way. If you use Writer you can set the language in the extra - language menu. This should work in Calc too. I never expected to find the language settings at the place where you choose fonts. Writer keeps font and language settings separate. 3) The menu controlling the calculation modes needs more entries and some easily reachable description (tooltip?): 3.1) Autocalc - The standard mode. Equivalent to pressing F9 after every change of cell content. Is already in the menu. 3.2) F9 - recalculation of all cells that depend of values that have been changed. This is useful for spreadsheets that contain time consuming calculations. If you do not want to wait for the the calculations to complete after you changed some cell values you can turn off autocalc and press F9 whenever you want to see new results. This is also already in the menu. Unfortunately it does not help if something is wrong with the spreadsheet. 3.3) Hard recalc [Ctrl+Shift+F9]. This is for situations where there are cells that get not updated by the previous mechanism. Should rebuild from scratch the information that tracks changes and recalculate all values. I think this function is implemented but the menu does not offer it. Therefore it is hard to find. 3.4) Very hard recalc. Hard recalc does not always work (see bug 43003). Therefore you need a functionality equivalent to saving a spreadsheet, reloading it and pressing [Ctrl+Shift+F9] (Reloding alone seems not to solve the problem of cells containing obsolete values). Could be integrated into the [Ctrl+Shift+F9] functionality. I see no need to have this as a separate function if it does not actually overwrite the original file. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #11 from m.a.riosv mari...@miguelangel.mobi --- Seems there is not language selected for the font options in the cell style, neither in default style. Selecting the language in default style works fine. I have not set up to create new files from windows explorer to verify. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #9 from m.a.riosv mari...@miguelangel.mobi --- Neither copying I have a crash: To reset user profile follow the instructions in: https://wiki.documentfoundation.org/UserProfile -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #10 from m.a.riosv mari...@miguelangel.mobi --- Sorry Albrecht, last comment was for other thread. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #6 from Albrecht Müller albrecht.muel...@astrail.de --- Thank you for the hint at the hard recalc functionality. After pressing [Ctrl+Shift+F9] my spreadsheet seems to show correct values which solves my current problem. I think it would be very useful to have a menu entry that lets you trigger a hard recalc as it can help in situations where something is wrong with the recalculation of modified cells. It should be next to the position where the other recalc options are (automatic recalculation on/off, recalc modified cells [F9]). Unfortunately I cannot provide a file to reproduce the issue. My spreadsheet contains data I do not want to share, and changing the data destroys the effect. As I do not know what triggers the problem I was not yet able to create an example file from scratch. You may have a look at bug 43003. This one is easy to reproduce, and for this example even a hard recalc is not hard enough. In order to see correct data you have to save and reload the changed spreadsheet. This behavior differs from my case, however, as saving and reloading does not change the numbers. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #7 from Albrecht Müller albrecht.muel...@astrail.de --- Created attachment 100156 -- https://bugs.freedesktop.org/attachment.cgi?id=100156action=edit Example file with working hyphenation This file was created by opening Calc, editing the empty spreadsheet and then saving the file. It contains one cell B2 which should display some German text which contains automatically generated hyphens. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #8 from Albrecht Müller albrecht.muel...@astrail.de --- Created attachment 100157 -- https://bugs.freedesktop.org/attachment.cgi?id=100157action=edit Example file with broken hyphenation This file was created by creating a new LibreOffice speadsheet using the Windows Explorer, and then opening it in Calc and editing it. It contains one cell B2 which should display some German text which should contain automatically generated hyphens. Words are split without hyphens at wrong positions. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #3 from Albrecht Müller albrecht.muel...@astrail.de --- The file containing the hypenation problem shows another one that I consider much worse: It does not reliably update the contents of the cells. When I use a calculation program the last thing I expect is that I have to double check the numbers by hand, and that is exactly the consequence of this problem. I report it here as it seems to be related to the original problem. It occurs in the same file, and some operations on cells are not performed correctly. One is hyphenation, the other is updating (recalculating) the cell content. While the hyphenation problem is easily to reproduce (see previous comment), I did not find a way to create an example file that shows the other one. Therefore I can give only a few observations here. They are based on experiments with a file I happened to save in a state which allows to reproduce the problem reliably. (1) The main symptom is that there are cells that do not display the correct results of the formula they contain. The numbers displayed seem to come from some previous calculations despite the fact that automatic recalculation is on and works for other cells. Pressing F9 to force a recalculation does not change anything. The formula reference chain seems to be broken. (2) Maybe the problem has common roots with bug 43003, which I could reproduce using LibreOffice calc Version: 4.2.4.2 Build-ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8. It is not the same problem as I do not use array functions, only built in functions like sum (Summe in German) and names for cells and cell ranges. Bug 44143 seems to be fixed in this version of Calc. (3) The problem seems to require a speadsheed of some minimum complexity. I was not able to build an example from scratch. (4) This problem is difficult to observe, as it occurs only rarely and it seems to disappear in many (but not all) cases when a cell is changed on which the content of the cell in question depends. Seems as if the broken reference chain gets repaired somehow. On the other hand a single table can contain quite a few cells containing wrong results. (5) A cell that refers to other cells only by names should show the same value as the original when it is copied to some other place. The copy of a cell with a wrong value shows the correct value at the target location. The net effect is that you can have two cells containing exactly the same formulas referring to exactly the same cells but showing different values. This behavior differs from the example in bug 43003. When I copied the cells F1 (after having changed A1 to $A$1) to some other places all the copies showed the same wrong value. (6) Undo does not work in the sense that it does not restore exactly the previous state: Adding a blank character at the end of formula in some cell which shows a wrong result usually does not change the semantics of the formula but forces the cell to show the correct result. The undo operation does not restore the wrong result. I tried this trick with the example given in bug 43003. It did work there on cell F1 (containing =INC(A1)), but not on matrix B1:C1 (containing '=INCDINC(A1)). The formula reference chain seems to remain broken in this case. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #4 from Albrecht Müller albrecht.muel...@astrail.de --- Additional information to the previous comment: The example file in bug 43003 has automatic recalculation turned off, during some experiments I forgot to turn it on. Therefore point (5) and (6) in the previous comment refer to the behavior when automatic recalculation is off. When it is on, cell F1 updates correctly, but not the matrix B1:C1. Editing the matrix formula without doing semantic changes did not trigger an update to the correct values. In this case it does not matter if automatic recalculation is on or off. Hyphentation works in this example file. Therefore I assume it has been created by saving a spreadsheet from Calc and not by using the Windows Explorer. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #5 from m.a.riosv mari...@miguelangel.mobi --- Automatic calculation or calculate [F9] does the recalculation of the cells with modifications in their precedents. There is the hard recalc [Ctrl+Shift+F9] to recalculate all cells and functions. https://help.libreoffice.org/Calc/Recalculate. Please attach a file where to reproduce the issue. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #2 from Albrecht Müller albrecht.muel...@astrail.de --- Thank you for showing me an example of working hyphenation. Your example works for me too, including the wrong hyphenation: it should be Zeilen-umbruch instead of Zeile-numbruch. After some analysis of the problem I think that working hyphenation is an immutable property of a particular spreadsheet: If you copy a cell range between a spreadsheet with working hyphenation into another where hyphenation does not work you will observe that hypenated cells are no longer hyphenated and vice versa. Cloning spreadsheets either by using some operating system copy command or the save as command in Calc preserves this property. It matters how you create the spreadsheet. If you start Calc without parameters Calc will show some empty spreadsheet. You can work with this and save it and you will get a document with working hyphenation. Another way to create a new spreadsheet is to use the Windows Explorer and use file - new - OpenDocument table document. If you do this you will get a document that does not support hyphenation. Can you confirm this observation? Note: I tried this with the German version of Windows 7 and using the German user interface of LibreOffice, so I am not sure if my translation of the commands is correct. During my experiments I observed another strange effect: I tried to compare the settings of the file where hypenation worked with those where it did not work. Therefore I opened both documents, selected corresponding cells and opened the dialog box you show in the attachment. With the dialog box open in both documents I could not switch between the documents any more. When I had opened the second dialog box and tried to switch to the other document by clicking in the caption bar of the first document the focus immediately switched back to the second document. If I did not release the mouse button the focus remained for about one second on the first document before switching back again to the second document. Using ALT+TAB shows a similar effect: If the focus is set to the first document it immediately switches to the second one. If I close one of the dialog boxes switching between the documents is possible again. I have got the impression that this problem is related to bug 79025 or bug 48300. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 --- Comment #1 from m.a.riosv mari...@miguelangel.mobi --- Created attachment 99681 -- https://bugs.freedesktop.org/attachment.cgi?id=99681action=edit Screenshot with hyphenation. Hi Albrecht, thanks for reporting. I can't reproduce the issue, with my locale in Spanish, selecting the font language German(Germany) for the cell, and the properties Wrap text, Hyphenation active. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 79027] Hypenation does not work in Calc cells.
https://bugs.freedesktop.org/show_bug.cgi?id=79027 m.a.riosv mari...@miguelangel.mobi changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||mari...@miguelangel.mobi Ever confirmed|0 |1 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs