You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/09/13 15:26:08 UTC

[Bug 55555] New: Adding a border to a cell with background pattern sets the pattern color to black

https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

            Bug ID: 55555
           Summary: Adding a border to a cell with background pattern sets
                    the pattern color to black
           Product: POI
           Version: 3.10-dev
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: gguillaud@cegid.com

Created attachment 30835
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=30835&action=edit
The java file to reproduce the problem

Hi,

I have a very strange problem with cells on which I want to have:
1) a colored background pattern
2) a border

I've just created a java class to reproduce the problem. First you can execute
it and you will get a XSLX file in which there will be some cells (25x25).
These cells have all a colored background pattern.

Now, in the java class, let's set boolean _DRAW_BORDER to true, compile and
execute. In the result file, you will now see that some cells have a border. In
these cells the background pattern is ok, but not the color which is now black.

This can be reproduced with POI1.9 and POI3.10b.

Thanks

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

--- Comment #3 from Gilles <gg...@cegid.com> ---
I still have the same issue using POI 3.10 final
I was hoping it would have been fixed. Will it be fix in POI 4.0 ?
Please answer me, I must say something to my applications's users ...

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

--- Comment #10 from Gilles <gg...@cegid.com> ---
Ok Nick, I understand. Thank you for your answer.
Regards
Gilles

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

Gilles <gg...@cegid.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #8 from Gilles <gg...@cegid.com> ---
Hi Nick, do you have any idea when this issue will be resolved ? Will it be in
3.11 final ? If it is not, I'll have to forget POI and choose another solution
:-(
Regards
Gilles

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

--- Comment #7 from Gilles <gg...@cegid.com> ---
Hi Nick,
I've just uploaded the 2 XSLX files. There are a lot of differences between
them. I do not understand everything, what I see is that the xl/styles.xml is
bigger in the "from POI" than in the "From Excel".

If you want to reproduce the problem, I've already uploaded a Java source file
which can do that.

Regards
Gilles

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

--- Comment #1 from Gilles <gg...@cegid.com> ---
Created attachment 30836
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=30836&action=edit
The result file with some bordered cells

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

Nick Burch <ap...@gagravarr.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #4 from Nick Burch <ap...@gagravarr.org> ---
If you recreate the file in Excel, unzip the POI .xlsx and the Excel .xlsx,
then compare the various xml files (especially style ones), how do they differ?

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

--- Comment #9 from Nick Burch <ap...@gagravarr.org> ---
(In reply to Gilles from comment #8)
> Hi Nick, do you have any idea when this issue will be resolved ?

It'll be fixed when someone (be they a POI committer, or a community member)
decides it's enough of a problem for them to sit down and write a patch...

If this bug matters to you, I'd suggest you join the dev list, and ask for
advice on how to debug this style of problem

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

Gilles <gg...@cegid.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

--- Comment #2 from Gilles <gg...@cegid.com> ---
I have the same problem using POI 3.10-beta2

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

Gilles <gg...@cegid.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

--- Comment #6 from Gilles <gg...@cegid.com> ---
Created attachment 31310
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31310&action=edit
Same sample file got from Excel

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 55555] Adding a border to a cell with background pattern sets the pattern color to black

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55555

--- Comment #5 from Gilles <gg...@cegid.com> ---
Created attachment 31309
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31309&action=edit
sample file generated using POI

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org