Apache OpenOffice (AOO) Bugzilla – Issue 19358
Bidi text alignment lost when embedding calc table in a writer document
Last modified: 2013-08-07 15:00:08 UTC
A well formed RTL table in Calc, becomes un-preventable (on screen and in print) when it is copied and pasted into Writer. *** Steps to reproduce: *** -1) you will need to have a Hebrew (or other bidi language) enabled keyboard support on your OS. 0) Tools -> Options... -> Language Settings -> Languages -> Complex text layout (CTL) support -> Enabled (check the box); so you will have the __ > || [left-to-right] and __ || < [right-to-left] tools on your toolbar. 1) Open Calc 2) Create a small Hebrew table with some Hebrew text aligned to the right (both with the [Align Right] tool and the [Left-to-right] tool (on the tool bar) <monotype text figure> +------------+------------+ | B NMULOC | A NMULOC | +------------+------------+ | 456 | 123 | +------------+------------+ </monotype text figure> (RTL text is written visually with ALL CAPS) 3) Format the cell: add borders to the cells (this will make the problem more visible later) 4) Copy the table. 5) Open Writer 6) Paste the table. 7) Select all (Ctrl-A) and use the [right-to-left] tool on the toolbar. *** What Happens: *** Before using the [Left-to-right] tool, number and alignment is correct, but Hebrew text is written backwards (e.g. NMULOC is written as COLUMN - not the visually this is wrong in Hebrew). <monotype text figure> +------------+------------+ | COLUMN B | COLUMN A | +------------+------------+ | 456 | 123 | +------------+------------+ </monotype text figure> (Note that ALL-CAPS represents RTL lettest but this test is written LTR) After using the [Left-to-right] tool, alignment lost. Text may drift to the next cell (to the left). The test on the left is out of view. The digits are swapped (e.g. 123 becomes 321). <monotype text figure> +------------+------------+ |OC A |NMULOC | +------------+------------+ | 654 | 321 | +------------+------------+ </monotype text figure> *** What should happen: *** After using the [Right-to-left] tool, the text should be formatted as in Calc. Numbers should stay unchanged. IMHO, this should be the case before using the [Right-to-left] tool, because the table in calc is already in RTL-ed. In short the table in writher should look like this: <monotype text figure> +------------+------------+ | B NMULOC | A NMULOC | +------------+------------+ | 456 | 123 | +------------+------------+ </monotype text figure>
DL->NN: Would you please takeover?
Reproduced, and it seems to happen only with spreadsheet objects. Maybe the LayoutMode isn't set. I'll have to look at it.
Fixed in CWS nn02. Changed: sc/source/ui/docshell/docsh4.cxx 1.33.34.1
reassigning to QA for verification.
reset resolution to fixed
verified in internal build cws_nn02
fix available in OOo680m40