Spreadsheet Charts don't honor the "no fill" attribute
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 50
- Forks
- 53
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 1
Description
when determining line and fill colors from an or element in an OOXML (XLSX) spreadsheet, there are special attributes possible for these: . If present, the color is effectively transparent.
This can be handled by augmenting color conversion routines for these element types to use a color configuration with 0.0 for opacity (full transparency) such as
new ColorProperties(new int[] {0, 0, 0}, 0d)
or
new SolidColor(0, 0, 0, 0d)
This file Hospital VBP Penalty Tool NEW.xlsx shows the issue. The series named "Axis" in each chart should have transparent (no) fill and line colors.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by locating the color conversion routines for OOXML and elements, then reproduce the issue with the attached Hospital VBP Penalty Tool NEW.xlsx file. The work is done when the "Axis" series in each chart has transparent line and fill colors whenever is present.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- data-visualization
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100