Bug 66123 - Can't set gte attribute with XSSFConditionalFormattingThreshold
Summary: Can't set gte attribute with XSSFConditionalFormattingThreshold
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 5.2.2-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2022-06-15 14:57 UTC by Dario Götze
Modified: 2022-06-25 11:59 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Dario Götze 2022-06-15 14:57:57 UTC
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
Comment 1 PJ Fanning 2022-06-15 15:33:52 UTC
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.
Comment 2 PJ Fanning 2022-06-15 16:02:18 UTC
Looks like gte=true is the default. I added r1901945.
Comment 3 Dario Götze 2022-06-15 16:16:00 UTC
Yes, it defaults to gte=true. The change looks good to me.