Issue 84434

Summary: Conditionnal formatting when imported from Excel missing vertical lines
Product: Calc Reporter: pagalmes.lists
Component: open-importAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.3Keywords: ms_interoperability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
The example file
none
Under Excel
none
Under OOo none

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.

Frank
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 
RFE
Comment 8 daniel.rentz 2007-12-11 15:59:29 UTC 
reopened
Comment 9 daniel.rentz 2007-12-11 16:00:44 UTC 
keyword
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.