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 2022/06/15 14:57:57 UTC

[Bug 66123] New: Can't set gte attribute with XSSFConditionalFormattingThreshold

https://bz.apache.org/bugzilla/show_bug.cgi?id=66123

            Bug ID: 66123
           Summary: Can't set gte attribute with
                    XSSFConditionalFormattingThreshold
           Product: POI
           Version: 5.2.2-FINAL
          Hardware: PC
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: dario@ok.de
  Target Milestone: ---

I am not able to change the gte attribute for the comparison mode with the
XSSFConditionalFormattingThreshold. I want to compare for > x and not for >= x.
I have seen that the CTCfvo has an option to set the gte attribute (which is my
required property?). But I am not able to access the CTCfvo directly or set it
over the Threshold, would be nice to do so.

Best regards

-- 
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 66123] Can't set gte attribute with XSSFConditionalFormattingThreshold

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

PJ Fanning <fa...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|blocker                     |normal

-- 
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 66123] Can't set gte attribute with XSSFConditionalFormattingThreshold

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

PJ Fanning <fa...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

-- 
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 66123] Can't set gte attribute with XSSFConditionalFormattingThreshold

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

--- Comment #2 from PJ Fanning <fa...@yahoo.com> ---
Looks like gte=true is the default. I added r1901945.

-- 
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 66123] Can't set gte attribute with XSSFConditionalFormattingThreshold

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

PJ Fanning <fa...@yahoo.com> changed:

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

--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
I don't know for definite but the derived code for CTCfvo seems to suggest that
you need to explicitly set get to true and that gte=false is inferred
otherwise. GTE is short for Greater Than Or Equal To.

Do you have evidence to show that you are getting GTE defaulting to true? E.g.
an xlsx file that someone can look at.

-- 
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 66123] Can't set gte attribute with XSSFConditionalFormattingThreshold

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

--- Comment #3 from Dario Götze <da...@ok.de> ---
Yes, it defaults to gte=true. The change looks good to me.

-- 
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