Issue 51436 - In Calc, Optimal Height incorrect for Khmer fonts, leading to partial display of text
Summary: In Calc, Optimal Height incorrect for Khmer fonts, leading to partial display...
Alias: None
Product: Internationalization
Classification: Code
Component: code (show other issues)
Version: 680m104
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks: 72107
  Show dependency tree
Reported: 2005-07-01 05:59 UTC by lists
Modified: 2017-05-20 11:13 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

JPG Graphic showing cell height issue (87.16 KB, image/jpeg)
2005-07-01 06:39 UTC, lists
no flags Details
screenshot showing same problem in MS WORKS 4.5a (49.19 KB, application/vnd.sun.xml.draw)
2005-07-02 08:53 UTC, Rainer Bielefeld
no flags Details
Example of mixing English and Khmer (19.98 KB, image/jpeg)
2005-07-02 09:26 UTC, lists
no flags Details
testkit for easy reproduction of the problem (13.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2005-07-02 10:16 UTC, Rainer Bielefeld
no flags Details
Test in OOo 3.0 beta (69.71 KB, image/jpeg)
2008-05-15 08:08 UTC, lists
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description lists 2005-07-01 05:59:47 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.
Comment 1 lists 2005-07-01 06:39:54 UTC
Created attachment 27597 [details]
JPG Graphic showing cell height issue
Comment 2 Rainer Bielefeld 2005-07-01 09:07:55 UTC
Hi javiersola,

pls. specify OS and Platform!
Comment 3 lists 2005-07-01 11:24:43 UTC
The problem was detected on 680_m109 runnin on Windows XP.
Comment 4 Rainer Bielefeld 2005-07-02 08:52:22 UTC
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" :-(
Comment 5 Rainer Bielefeld 2005-07-02 08:53:45 UTC
Created attachment 27649 [details]
screenshot showing same problem in MS WORKS 4.5a
Comment 6 lists 2005-07-02 09:23:10 UTC
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.

Comment 7 lists 2005-07-02 09:26:02 UTC
Created attachment 27651 [details]
Example of mixing English and Khmer
Comment 8 Rainer Bielefeld 2005-07-02 10:15:23 UTC
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
Comment 9 Rainer Bielefeld 2005-07-02 10:16:52 UTC
Created attachment 27652 [details]
testkit for easy reproduction of the problem
Comment 10 lists 2005-07-02 10:45:36 UTC
The example is good. Those characters display all the height without having to
install all the nuissances necessary of Khmer rendering in the computer.


Comment 11 falko.tesch 2005-07-08 06:46:06 UTC
FT->NN: Something you can fix in 2.0.2? If not please target it to later.
Comment 12 niklas.nebel 2006-01-23 11:37:00 UTC
This would require some general changes to the way row heights are determined,
so I'm changing the target to 3.0.
Comment 13 niklas.nebel 2006-07-07 19:26:25 UTC
changing target
Comment 14 ace_dent 2008-05-15 00:22:12 UTC
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
or consider trying the new OOo 3 BETA (still in testing):

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 :

Many thanks,

Cleaning-up and Closing old Issues as part of:
~ The Grand Bug Squash, pre v3 ~
Comment 15 lists 2008-05-15 08:07:05 UTC
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).

Comment 16 lists 2008-05-15 08:08:39 UTC
Created attachment 53661 [details]
Test in OOo 3.0 beta
Comment 17 Marcus 2017-05-20 11:13:16 UTC
Reset assigne to the default "".