Created attachment 101939 [details] broken symbol table as summarized, in some localized LO editions some of the symbols are missing (at least de and zh_CN). it seems to be platform independent as it has been verified on windows 7 / 8 and ubuntu 14.04. even the examples at the elements dock are lacking of the original greek signs. maybe a re-occurrence of #37869, but i guess 64945 is the interesting one to look at.
Confirmed that it shows in 4.1.6 and 4.2.5 with zh_cn but not in arabic UI. Confirmed it doesnt show in 4.3.0 with zh_cn, japanese, arabic, and even KeyID (qtz) UIs.
Created attachment 101940 [details] missing symbols in chinese UI
Working in DE Version: 4.2.1.1 Build-ID: d7dbbd7842e6a58b0f521599204e827654e1fb8b Version: 4.3.0.0.beta1 [en of course] Build-ID: b7cfa1eab1cb1e94f71d6df6612b73f231d0bf92 NOT Working in Version: 4.3.0.1 DE Build-ID: 67f5430184326974072b65403ef1d9d934fc4481 So a nasty regression between 4.2 and 4.3 affecting all Math users Adding it to MAB
Also reproduce with 4.2.5.2, Fedora 20 x86, zh_CN UI. Changing version accordingly. Switching to en_US UI do not resolve the problem.
Created attachment 101963 [details] 3.6.7.2 screenshot (works OK) It works OK in 3.6.7.2 release.
Created attachment 101964 [details] 4.2.5.2 screenshot (does not work) It does not work in 4.2.5.2
Created attachment 101965 [details] 4.3.0.1 screeshot (does not work) It does not work in 4.3.0.1. I also tried to remove all the "libobasis4.3-[lang]", but still do not work.
Confirmed in 4.3.0.4 (Windows 8.1), german GUI; Workaround I've found the following workaround quirk: Replacing the "..program\resource\smde.res" resp. "smfr.res", "smes.res" etc. by the english version *smen.res* will do the trick: lower case greek symbols à la "%pi" are working again. Problem: I can live with a partial untranslated GUI, but not with a non functional formula editor. So I can still use all my 15 year old math documents...
Confirming the bug on x86_64 build of LibreOffice 4.3.0.4 on GNU/Linux, CS locale. Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0
(In reply to comment #8) > Confirmed in 4.3.0.4 (Windows 8.1), german GUI; Workaround > > I've found the following workaround quirk: > > Replacing the "..program\resource\smde.res" resp. "smfr.res", "smes.res" > etc. by > the english version *smen.res* will do the trick: lower case greek symbols à > la "%pi" are working again. > > Problem: I can live with a partial untranslated GUI, but not with a non > functional formula editor. So I can still use all my 15 year old math > documents... Thank you, this workaround works also on GNU/Linux. The appropriate file is located in package libobasis<version>-<lang>-math_*. For me the smcs.res from libobasis4.2-cs-math_4.2.5.2-2_amd64.deb works fine. Btw.: it seems, that the libobasis4.3-en-gb-math_4.3.0.4-4_amd64.deb file also includes broken symbol definition, since it did not help me. Thaks once again.
Still not fixed in 4.3.1.1 (Windows 8.1), german GUI; Workaround Had to adapt the workaround quirk: I've found the following workaround quirk: Replacing the "..program\resource\smde.res" resp. "smfr.res", "smes.res" etc. by the english version *smen-US.res* (was smen.res in older vesion) will do the trick: lower case greek symbols à la "%pi" are working again.
Another workaround: Replacing the smde.res (or others) by an old version from 4.2 works too, and it has the advantage using the correct spelling (by replacing with the smen_US.res one must then use the english spelling of variables).
(In reply to comment #12) Workaround works for me (Win 8.1). Thanx. Just to let you know: The bug occurs only when updating. A fresh installation (done on a new tablet pc with no LibreOffice installed) works as expected.
With Mageia 5 ( Build ID: 4.3.1.1-1.mga5 ), I have this problem.
Not reproducible for me under Ubuntu 14.04 x86-64: - Version: 4.3.2.0.0+ (Build ID: b2d54aa61607e477cb4b81f1a70e555ee3adb0af) - Version: 4.4.0.0.alpha0+ (Build ID: e6369973702286d92bfc34ab8305d4a9bcf5c27e) both versions build at home. Best regards. JBF
Same problem with LO 4.3.1.1 french/Win Seven 64
Dataloss : with french LO 4.3.1.1 1 - create a doc including a formula with a working version of LO or AOO 2 - in the formula just add %pi, close the formula editor (you can see π) 3 - with LO 4.3.1.1 open the doc (you still can see π), open the formula. you can see %PI has replaced %pi. Close the editor then you will see that Π has replaced π 4 - make any change to the doc, save and close 5 - Open the doc with a working LO or AOO the Π is definitively in the formula
As this bug seems to be in 4.2.5.2 shouldn't it be a MAB 4.2, not a MAB 4.3 ? And, as there is an unusable function and data loss, shouldn't it be a blocker ?
I have the same problem in LO 4.3.1.1 and 4.3.0.4.
A bibisect would be fantastic here in helping us resolve the problem: https://wiki.documentfoundation.org/QA/HowToBibisect
(In reply to comment #20) > A bibisect would be fantastic here in helping us resolve the problem: > https://wiki.documentfoundation.org/QA/HowToBibisect @Joel: I don't know how we can do a bibisect on this bug: it appears *only* with locales, and intermediate builds are only English US (if I'm not wrong).
No problem in 4.2.6.2 french LO/7x64
Still broke in version 4.3.1.2 Windows 8, x64, german locale
*** Bug 83161 has been marked as a duplicate of this bug. ***
*** Bug 82040 has been marked as a duplicate of this bug. ***
All suggestions below don't work with LO for MAC OS X in pt-Br.
*** Bug 83265 has been marked as a duplicate of this bug. ***
Yes, still buggy, also on Debian GNU/Linux x86_64, version 4.3.1.2... (In reply to comment #23) > Still broke in version 4.3.1.2 Windows 8, x64, german locale
*** Bug 83385 has been marked as a duplicate of this bug. ***
Can't be bibisected.
*** Bug 83417 has been marked as a duplicate of this bug. ***
Hi, I tried all workarounds in the Italian locale with no success: any substitution of smit.res with the US version from the same install or the italian version from Openoffice 4.0.1 did not get the symbols back. I have now painstakingly readded manually all missing Greek letters one by one, I am still not sure this works with already existing formulas since in some experiments when re-editing old formulas lowercase names of symbols added manually when turned into uppercase.
I have experimented a little bit more and tragically my manual effort to recreate missing symbols in the formula catalog does NOT work 100%: - when I create a formula I can insert lowercase Greek letters and they appear correctly; - upon re-editing such formulas, all Greek letters that have an UPPERCASE equivalent (for example sigma and SIGMA) are automatically turned into uppercase, corrupting your formula completely. You are then forced to reconvert manually to lower case all symbols that are actually so; but this works only until the next editing, when the devilish automatic uppercase conversion will take place again.... Any workaround to this would be greatly welcome.
Further, complicated, news: the problem described in the previous comment (unwanted automatic uppercase conversion) seems to appear not always but in only some instances: - when you edit the formula for the first time after opening the file where it is contained, but not in further editing instances in the same session. If you close the file and reopen it, the first editing will induce it again. - when you copy and paste the formula between two different document types: for example, if you have a formula in a Writer doc and copy and paste it into a new calc sheet, wrong uppercase conversion will take place; if you instead copy and paste it into another Writer doc, it will not. The same will happen in the opposite direction (from a calc sheet to a writer doc), and also when copying it to an Impress file etc from a different file type. For anybody needing to create and edit many formula, this a complete nightmare. Thus, creating manually the lowercase symbols is not a practically useful workaround. Thanks for your attention
I am sorry, but all efforts to clarify a defined mechanism for the problem is failing. Now I am experiencing unwanted uppercase conversion even in the same document when I copy and paste a second instance of a formula. What is happening seems to be somehow changing from time to time.
As told in comment 18, this bug should be considered as a blocker Unusable function and data loss In one week 6 bugs has been marked as a duplicate of this one, 16 users are following this bug LO 4.3.2.1 should be for this week, and the bug isn't solved (is anyone working on it ?) The only workaround is to go back to 4.2.6
Do you have the problem with a fresh installation (uninstall first the current version) and a clean new user profile? Still no problem for me with LO 4.3.2.0.0+ build at home under Ubuntu 14.04 x86-64 with en-US and FR langpacks. Best regards. JBF
What do you mean by a "fresh" install? If you simply uninstall the previous version before installing the new one, all your personalized settings will be maintained, and this is probably not what you mean by a "clean new user profile". However, the problem is that I have literally dozens if not hundreds of personalised settings, and I would have to ponder carefully if this trial is worth wiping them all and restart personalizing the program again from scratch. A hell of a waste of time to be sure. I could do this experiment on an old PC in my office, maybe tomorrow I'll give it a try. In any case, to be clear all my posts refer exclusively to LibreOffice Italian localization. I have never tried any other.
No need to delete - just back up the folder and delete the original. Then you can at least see if it's profile related: https://wiki.documentfoundation.org/UserProfile
I have now uninstalled 4.3.1 and installed again 4.3.0.4, the missing symbols in the catalog problems - as well as the uppercase unwanted conversion - seems to be there as well.
Downgrading to 4.2.6.3 the uppercase automatic conversion is NOT present. I had re-aded lowercase Greek letters manually, so I cannot tell if they would automatically be here now - however, the iGreek category that exhibited the same problem is now restored, so probably everything is Ok here with 4.2.6
*** Bug 83462 has been marked as a duplicate of this bug. ***
@Andy Comment 32 You said to have added all missing Greek letters. Did you add also their lowercase names? Else, they will not be recognized in your formulas. regards, Jacques
Actually I don't think there should be any difference between fresh install and update/reinstall, at least on GNU/Linux. Since the bug is caused by broken symbol table for Math (e.g. smcs.res in CS locale), included in package libobasisX.Y-cs-math_X.Y.A.B-C_amd64.deb and installed in /opt/libreoffice4.3/program/resource, which is not a directory changeable by user, the behaviour should be the same in both cases (unless a user-defined symbol table exists in user's profile folder). Another proof of guilt of this file is its filesize. In version 4.2.5.2, which works good for me, its filesize is 63152 bytes (in package libobasis4.2-cs-math_4.2.5.2-2_amd64.deb). In version 4.3.0.4, which is the first broken, the filesize of smcs.res shrunk to 60716 bytes, and in 4.3.1.2 the filesize is the same. A funny thing is, that the conversion from lowercase greek letters to uppercase greek letters appears ONLY with broken symbol table. When I use older smcs.res file from LO 4.2.5.2, it does not appear. My suggestion is simply to compare smXX.res files from older locales of LO and if they are larger than current ones, there is a large probability, that this locale is currently buggy. Regards, Karel Hruska (In reply to comment #37) > Do you have the problem with a fresh installation (uninstall first the > current version) and a clean new user profile? > > Still no problem for me with LO 4.3.2.0.0+ build at home under Ubuntu 14.04 > x86-64 with en-US and FR langpacks. > > Best regards. JBF
In response to Jacques comment 43: You said to have added all missing Greek letters. Did you add also their lowercase names? Else, they will not be recognized in your formulas. Yes, I have added them in the sense that I: - clicked the "edit..." button in the Catalog window; - in the editing window I clicked on the lowercase Greek letter I wanted in the matrix showing all symbols; - then I modified its name in the first field in the lower half of the window, giving it the name it had in older releases; - for example, when you choose the lowercase sigma this fields shows "Ux03C3", I replaced this text with "sigma", then clicked on "add" the buttons on the lower right side of the window The same procedure was repeated manually for all other lowercase Greek letter missing, i.e. all those whose name does not begin with the prefix "var" (these are the only ones left in 4.3.1). This would have been annoying but doable if it resolved the issue while waiting for a fix; however the problem is that this manually created symbols caused the "unwanted uppercase conversion" when using the manually created symbols that I described. It looks as if there were an auto-check of formula code correctness, and this could not take into account symbols added by the user...
I have partially solved the problem after I removed the LO user config files, in MAC [~/Library/Application/LibreOffice] after that the lowercase Greek letters works in default user interface. However, if I change the user interface to PT-BR the problem returns. To me, the Greek letters is more important that the user interface.
Please let me for once add a comment which is "political" rather than "technical": to me, the difficulties caused by bugs such as this are not only due to my own production work with LO. If it were just for this (which is of course important) any workaround, even a difficult to implement one, would do. The problem is that I am a teacher and use LO in lectures continuously, and do this both because it a free software and to spread its usage and appreciation. So how can I go in class to teach statistics and tell students that the app is so buggy that you cannot write math formulas anymore, or that you must apply arcane procedures to be able to do that again, or that you must change locale? So I agree, to ME personally, locale is quite unimportant, but for the context where I use LO with the public, switching locale to a foreign one is simply unthinkable, unless you do not care making LO the object of blatant complaints, people not wanting to use it, etc. Unfortunately this is at present the case also with another bug, n. 83461, related to a significant bug in the "frequency" function, something that I use everyday in class. If you have a look at it and would like to express interest, it would be nice. Thanks for your attention,
Confirmed in 4.3.1.2, locale LT (Lithuanian), system Kubuntu 14.04 (64b): lower-case "beta" is missing.
On pc Debian x86-64 with LO Debian package 4.3.0.4, I could reproduce this. However, I don't reproduce this with master sources updated yesterday. Could someone give a try to a daily build (master sources)? (see http://dev-builds.libreoffice.org/daily/master/)
Hi Julien, There's no issue with master. Problems come with locale helppack installation, and errors in "smxx.res". There, uppercase letters wording only is the visible difference. Jacques
Another workaround I found with Arch Linux' s Fresh package of 4.3.1.2. If you add the symbols manually in your locale and then change the interface language to English, the lower-to-upper conversion stops somehow and even reverts. Not sure why though.
I can reproduce this issue on 4.3.1.2/OSX with the "de" language pack. However, if I take a fresh build from master and add the contents of the "de" language pack from 4.3.1.2*, it works as expected - e.g. a lower case %sigma is now shown correctly. Although mixing and matching versions and langpacks is probably not recommended in general, if the problem is in fact already fixed in master this might provide a path for finding where through bisection? (* Language packs don't seem to be built for the dailies and I'm not sure of the procedure for building them from source)
Functionality is still broken in 4.3.2.1 French Seven/x64
broken symbol table I confirmed same problem with version 4.3.1.2 French, installed on Windows 7 (built). Uncontrolled lower to upper case modifications. Tried to uninstall, delete all personal settings in "Roaming", then re-install same built. No way, still the same mess. Old files created with with version V4.1 and read-only protected (were not modified with v4.3) are immediately contaminated when opened with v 4.3.1.2. This is a plain disaster, due to the high number of formulae that need now to be restored. I will try replace my French locale version by a US one, but hope it will support the French keyboard and already written text with accents and special character set. I hope someone will be able to fix that bug, otherwise the efforts of all non-English LO communities that need Math will become a bit vain... regards, FT
found the problem
David Tardon committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=03626d7940d5e2fc2abf65ef1b49a7a89623f08f fdo#80650 src transl. merge must be case sensitive The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 83845 has been marked as a duplicate of this bug. ***
David Tardon committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=40716a03b60e4d5014a2ddf194f02a474b122a18&h=libreoffice-4-3 fdo#80650 src transl. merge must be case sensitive It will be available in LibreOffice 4.3.3. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
David Tardon committed a patch related to this issue. It has been pushed to "libreoffice-4-3-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=82b6e98494792f7b38ce19f4b0664648de48a997&h=libreoffice-4-3-2 fdo#80650 src transl. merge must be case sensitive It will be available already in LibreOffice 4.3.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
This is truly good news. BUT is there any date for the 4.3.2 release? I checked the official release planning and it seems that 4.3.2 should already be out as an RC, but there is no trace of it on the web site. This is extremely important to me because I have to install LO in our laboratories at the university for the forthcoming semester, and I have to decide which version to use. At the moment I could use 4.2.6 to avoid math formula problems, but that release has another relevant problem for us (text objects in Calc graphs disappear after saving and reopening files; this has been solved in 4.3.x).
Need a backport to LibreOffice 4.2.7, please https://wiki.documentfoundation.org/ReleasePlan/4.2#4.2.7_release
*** Bug 84010 has been marked as a duplicate of this bug. ***
(In reply to comment #62) > Need a backport to LibreOffice 4.2.7, please > https://wiki.documentfoundation.org/ReleasePlan/4.2#4.2.7_release I do not see this problem in 4.2.6.3.
(In reply to comment #61) > This is truly good news. > BUT is there any date for the 4.3.2 release? 4.3.2 RC2 is released today. You can download it via dev-build server: http://dev-builds.libreoffice.org/pre-releases/ It shows in the release notes that this bug is fixed in RC2. http://dev-builds.libreoffice.org/pre-releases/src/bugs-libreoffice-4-3-2-release-4.3.2.2.log
I am sorry, but I don't think, that the bug will be fixed at least in Czech localization of LO 4.3.2.2. I have downloaded the Czech translation and the filesize of smcs.res is still 60716 bytes, which is the wrong one (see comment #44). I am afraid, that the bug will be reopened... If my impressions are wrong, please apologize me... Karel Hruska (In reply to comment #65) > (In reply to comment #61) > > This is truly good news. > > BUT is there any date for the 4.3.2 release? > > 4.3.2 RC2 is released today. You can download it via dev-build server: > http://dev-builds.libreoffice.org/pre-releases/ > > It shows in the release notes that this bug is fixed in RC2. > http://dev-builds.libreoffice.org/pre-releases/src/bugs-libreoffice-4-3-2- > release-4.3.2.2.log
Bug is fixed for me with fr UI: - Win 7, LibO 4.3.2.2 (Build ID: edfb5295ba211bd31ad47d0bad0118690f76407d) parallel install with si-gui - examples in left tab are fine - old documents containing formula with lower Greek letters are fine - create a new document with formula with lower Greek letters, save, close LibO; reopened document is fine
Sorry, I tried LO 4.3.2.2 in Wine and the symbol set is full. My apologies and thank you for fixing the bug! Karel Hruska (In reply to comment #66) > I am sorry, but I don't think, that the bug will be fixed at least in Czech > localization of LO 4.3.2.2. I have downloaded the Czech translation and the > filesize of smcs.res is still 60716 bytes, which is the wrong one (see > comment #44). I am afraid, that the bug will be reopened... > > If my impressions are wrong, please apologize me... > Karel Hruska > > (In reply to comment #65) > > (In reply to comment #61) > > > This is truly good news. > > > BUT is there any date for the 4.3.2 release? > > > > 4.3.2 RC2 is released today. You can download it via dev-build server: > > http://dev-builds.libreoffice.org/pre-releases/ > > > > It shows in the release notes that this bug is fixed in RC2. > > http://dev-builds.libreoffice.org/pre-releases/src/bugs-libreoffice-4-3-2- > > release-4.3.2.2.log
*** Bug 84319 has been marked as a duplicate of this bug. ***
*** Bug 84865 has been marked as a duplicate of this bug. ***
Sorry guys, on Mac OsX 10.10 with LO 4.3.2.2 and German language pack the bug is NOT fixed. Perhaps the symptoms have changed slightly. Now small greek letters won't become large ones, but they simply don't exist anymore: E.g. a %pi in a math formula will be shown as %pi even after closing the formula editor. As professor in electrical engineering using LO for all lectures this is a severe show stopper. Please fix this ASAP!!!!!!
please open a new clean report with the current new status of the bug and put this bug link under See Also
(In reply to Harry from comment #71) > Sorry guys, > > on Mac OsX 10.10 with LO 4.3.2.2 and German language pack the bug is NOT > fixed. > > Perhaps the symptoms have changed slightly. Now small greek letters won't > become large ones, but they simply don't exist anymore: > > E.g. a %pi in a math formula will be shown as %pi even after closing the > formula editor. > > As professor in electrical engineering using LO for all lectures this is a > severe show stopper. > > Please fix this ASAP!!!!!!
@Harry, Please test a build of 4.4.0 alpha1+ for OSX as well and report result against that on a new bug. http://dev-builds.libreoffice.org/daily/master/MacOSX-10.10@61/ Thanks.
Please also note: As discussed on bug 84865, it may be necessary to reset your user profile before the fix is effective
OK guys, removing the profile and reinstalling LO afterwards worked out alright. Thank you very much for your quick response! I still having some issues with a varphi now being a phi and the varphi being something really weird but since that has changed a while ago I will check if a correspond has already been reported.