-
Notifications
You must be signed in to change notification settings - Fork 1.8k
This issue was moved to a discussion.
You can continue the conversation there. Go to discussion →
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Solid fill become black #272
Comments
I recently had cause to use a solid fill myself, and no problem on it (sets an off-red background) - cell.fill = {
type: "pattern",
pattern: "solid",
fgColor: {
argb: "FFFF7D7D"
},
bgColor: {
argb: "FF000000"
}
} Could you have done it slightly differently? (As a side note, Excel can really mess up with fills on empty cells at the end of rows - it's ugly). |
@StephanMeijer I've just published 0.4.2, which I'm hoping will resolve this issue. I've fixed an issue with handling themes which can cause the effects you're seeing. |
@guyonroche I have the same issue even after updating to 0.4.2 also I am using Excel 2016 to read the output xlsx |
@StephanMeijer @guyonroche I found that after setting both fgColor and bgColor to the same value I get my intended fill color with black text.
Will yield a yellow background with black text of "Test Text" |
fgColor is the color of your filling. you only need to specify fgColor if you're using this is how you fill with red color:
|
Current doc for cell filling could lead to misunderstanding on how to apply a simple fill color to a cell. Related to exceljs#272
I think this issue is legit as I stumbled on the proper usage of cell filling today again. I opened a PR to clarify the doc about it. |
Current doc for cell filling could lead to misunderstanding on how to apply a simple fill color to a cell. Related to #272
This issue was moved to a discussion.
You can continue the conversation there. Go to discussion →
When using solid fill, the cell seems to become black entirely. It might be the case because I am using LibreOffice. Google Spreadsheets does not color the cell at all.
The text was updated successfully, but these errors were encountered: