Issue 23423 - cell directionality lost when importing from excel to calc
Summary: cell directionality lost when importing from excel to calc
Status: CONFIRMED
Alias: None
Product: Internationalization
Classification: Code
Component: BiDi (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks:
 
Reported: 2003-12-10 15:58 UTC by sforbes
Modified: 2013-08-07 14:59 UTC (History)
6 users (show)

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


Attachments
example (19.50 KB, application/vnd.ms-excel)
2003-12-10 15:59 UTC, sforbes
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sforbes 2003-12-10 15:58:46 UTC
When importing a spread sheet from MS Excel to Calc, the directionality settings
of cells are lost, leading to incurrect display of the document.

Sample file attached.
Comment 1 sforbes 2003-12-10 15:59:58 UTC
Created attachment 11870 [details]
example
Comment 2 sforbes 2003-12-10 17:08:50 UTC
added Dina as cc, as this is a highly visible bug that tkos should be aware of
Comment 3 Dieter.Loeschky 2004-02-05 10:49:00 UTC
DL->OC: Could you please handle this?
Comment 4 oc 2004-02-06 09:22:50 UTC
The text alignment is general. Excel checks the first character of the cell to
determine which direction to use for general. This is not a problem of the
import filter, this has to be handled by the core
Comment 5 niklas.nebel 2004-02-06 10:36:12 UTC
Falko, it was left that way on purpose - "Default" alingment is still left for
text, right for numbers. In the imported example document, this doesn't look good.
Comment 6 falko.tesch 2004-02-10 16:35:38 UTC
FT: Excels amd Calcs "General" text alignment are interpreted different:
Excel: Alignment depends on cell content
Calc:  Alingment is always left for text and always right for numbers
Thus all text with "Default" alignment from Excel is always left aligned in Calc.

Solution 1:
When importing Excel checking based on Excels rules for alignment and hard
format it to right aligned if applicable.

Solution 2:
Behave completely like Excel.

Question: Is option 2 desired? I have no input from Arabic countires on such issue.
Comment 7 sforbes 2004-02-11 14:27:42 UTC
>Question: Is option 2 desired? I have no input from Arabic countires on such issue.

notice my issue #17513 (which was resolved won't fix)- in effect, it is asking
for something similar to option 2.

I don't know about Arabic- so I am cc'ing some people who reported Arabic
related bugs. I hope that they will voice their opinions.
Comment 8 Frank Schönheit 2004-02-11 15:00:07 UTC
removing myself from cc. Sorry, I can't give you any input on this (only once
stumbled upon a bug in an arabic version, but opinions or ideas on the general
topic)
Comment 9 falko.tesch 2004-03-30 11:46:28 UTC
FT: This issue is not solved nor is there any input from Arabic stakeholders, so
I have to postpone this issue to Office Later.
Fweel free to re-target this issue once there are more information available.
Comment 10 meshcurrent 2004-03-30 14:38:19 UTC
I think I would prefer option 2.
Comment 11 Unknown 2004-03-31 11:09:11 UTC
I agree that option 2 is better
Comment 12 Unknown 2004-07-21 20:46:16 UTC
Please add keywords: ms_interoperability
Comment 13 falko.tesch 2005-10-20 15:54:54 UTC
FT: Please verify and assign to developer if applicable, thx.
Comment 14 oc 2008-09-25 13:25:46 UTC
OC=>DR: At the moment the used font determines the direction but it would be
better to check if the characters are ASCII or BIDI to get the direction
Comment 15 daniel.rentz 2009-09-09 18:49:10 UTC
new target