Issue 84434 - Conditionnal formatting when imported from Excel missing vertical lines
Summary: Conditionnal formatting when imported from Excel missing vertical lines
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability
Depends on:
Reported: 2007-12-10 15:47 UTC by pagalmes.lists
Modified: 2013-07-30 02:37 UTC (History)
1 user (show)

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

The example file (225.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-12-10 15:47 UTC, pagalmes.lists
no flags Details
Under Excel (31.26 KB, image/png)
2007-12-10 15:48 UTC, pagalmes.lists
no flags Details
Under OOo (25.91 KB, image/png)
2007-12-10 15:48 UTC, pagalmes.lists
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pagalmes.lists 2007-12-10 15:47:12 UTC
Have a look at the screenshots. When importing the file in OOo, some part of the
formatting is lost.
Comment 1 pagalmes.lists 2007-12-10 15:47:38 UTC
Created attachment 50211 [details]
The example file
Comment 2 pagalmes.lists 2007-12-10 15:48:04 UTC
Created attachment 50212 [details]
Under Excel
Comment 3 pagalmes.lists 2007-12-10 15:48:21 UTC
Created attachment 50213 [details]
Under OOo
Comment 4 frank 2007-12-11 09:29:37 UTC
Hi Daniel,

I don't think it's a bug because the conditional format sets only the border on
top of the cell and the border to the left and right are set by the cell
formatting itself. The use of conditional formatting implies IMO that it
overrules the settings for cellformats, otherwise it seems to be not really useful.

What do you think ? Can we change something here or better should we do so ? If
do, please set the target and confirm the Issue.

Comment 5 daniel.rentz 2007-12-11 10:00:46 UTC
This is a limitation of Calc. Excel allows to change single border lines in
conditional formattings, as done in the attached example: The upper border of a
cell is set to "thin/black", the other borders remain untouched. Calc only
allows to change all border lines of a cell or no line, therefore the
conditional formatting in Calc sets the upper line and clears the other three lines.
Comment 6 pagalmes.lists 2007-12-11 15:33:24 UTC
Well, shouldn't the Calc behaviour be change some day in the future (even is the
future is very far away)? For users, this is a bug, as the behaviour is not what
they expect.

I think that the issue should not be closed. Or at least, a new RFE should be
written to change this (maybe send to requirements?).

dr -> could you do what you think is best? Thanks.
Comment 7 daniel.rentz 2007-12-11 15:59:10 UTC
Comment 8 daniel.rentz 2007-12-11 15:59:29 UTC
Comment 9 daniel.rentz 2007-12-11 16:00:44 UTC
Comment 10 pagalmes.lists 2007-12-12 07:35:33 UTC
dr -> thanks :-)
Comment 11 bettina.haberer 2010-05-21 16:14:04 UTC
Changed the owner to 'requirements'.
Comment 12 Rob Weir 2013-07-30 02:37:50 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.