Apache OpenOffice (AOO) Bugzilla – Issue 51436
In Calc, Optimal Height incorrect for Khmer fonts, leading to partial display of text
Last modified: 2017-05-20 11:13:16 UTC
When typing Khmer text in a Calc cell using Khmer locale, the final result (once the cell has been existed only displays part of the text, the cell not being high enough to fit the (specially high) Khmer text. Performing Format->row->"optiomal height" does not change the result. Adjustment by hand leads to correct display. Example is attached.
Created attachment 27597 [details] JPG Graphic showing cell height issue
Hi javiersola, pls. specify OS and Platform!
The problem was detected on 680_m109 runnin on Windows XP.
I see the problem, but my suspect is that it is a problem with the font set and not with OOo. As you see in my attached screenshot, the same problem appears in MS Works 4.5a. Du you see any indication that the reported problem is something special with OOo? Unfortunately, on My PC the font doesn't look very "khmer" :-(
Created attachment 27649 [details] screenshot showing same problem in MS WORKS 4.5a
What you see in the example is normal behaviour in the font. In Khmer script, if a consonant is followed by other consonants (as in the word STRA), the 2nd and 3rd consonants are written as subscripts of the first one, some vowels cann also be written below. Khmer can have up to three lines of writing below the normal writing line (and one or two above). In order to accomodate that, the height of the font is much higher, and within this height, English characters included in the font are aligned with the base line of writing. When you align Khmer text to the lower part of the box, it will be higher that a purely Latin font, and when you align to the top, it will probably be lower, because of the upper space needed. The problem seems to be that Calc is not taking the real height of the font for Optimal Heigh, but a standard height based on the number of points in which it is displayed. 12 points for Khmer takes much more than 12 points for Latin. It is not only the case of Khmer. This problem exists for many Indian and South East Indian languages that require a larger height for the same reason (all the scripts derive from the same place). We could have done Khmer smaller, so that at 12 points all lines of writing took the same vertical space as a capital Latin letter, but, then when a text is written mixing English and Khmer (quite usual), either English is too big or Khmer unreadable. Such fonts cannot be used in localisation processes. Khmer OS System has been especially developed to use the least possible vertical space for Khmer (even cutting text sometimes), but even then it will not fit into the space for a 12 point Latin font. Please see attached example of mixing Latin and Khmer scripts. Desirable behaviour would be that the Optimal Row heigh adapts to the fonts declared height.
Created attachment 27651 [details] Example of mixing English and Khmer
I checked with 2.0 (1.9.m104) English version WIN XP: [680m104(Build8913)] and can confirm problems with auto row hight adaption. Because cannot find 680 m109 I set version to m104 Font set for testing can be downloaded from a.m. URL javiersola, do you agree with my test set "Testtext.odt" to demonstrate the main problem?
Created attachment 27652 [details] testkit for easy reproduction of the problem
The example is good. Those characters display all the height without having to install all the nuissances necessary of Khmer rendering in the computer. Javier
FT->NN: Something you can fix in 2.0.2? If not please target it to later.
This would require some general changes to the way row heights are determined, so I'm changing the target to 3.0.
changing target
This Issue requires more information ('needmoreinfo'), but has not been updated within the last year. Please re-test with one of the latest versions of OOo - the problem(s) may have already been addressed. Either use the recent stable version: http://download.openoffice.org/index.html or consider trying the new OOo 3 BETA (still in testing): http://download.openoffice.org/3.0beta/ Please report back the outcome so this Issue may be closed or progressed as necessary - otherwise it may be Resolved as Invalid in the future. You may also wish to search for (and note) any duplicates of this Issue that may have advanced further : http://www.openoffice.org/issues/query.cgi Many thanks, Andrew Cleaning-up and Closing old Issues as part of: ~ The Grand Bug Squash, pre v3 ~
Just checked the latest build, and it still has the same problem. Please see graphic attached. Cells A1 and A2 have normal text, where it is not displayed completelly (the top part is not displayed). Cell A3 has the same text, but it has been enlarged by hand, to show the complete text. Cell A6 shows what you seen when you are typing (the complete text).
Created attachment 53661 [details] Test in OOo 3.0 beta
Reset assigne to the default "issues@openoffice.apache.org".