Individual Cell Styles about picoxlsx HOT 5 CLOSED

Hi
Thank you for the report. I will have a look at this ASAP.

But it could be that we have a reference problem here (probably a bug) with the Basic Styles. The styles are stored as references not values, and redefining BasicStyles.ColorizedBackground may override all references in the cells.
As quick fix, you could try to use the copy function of the style class to create two distinct styles instead of of using BasicStyle.ColorizedBackground directly.

But like said, I will look into it.

from picoxlsx.

Gave that a quick test, same results

Style evenStyle = new Style().CurrentFill.BackgroundColor = "a6a1a1";
Style diffStyle = new Style();
diffStyle.CurrentBorder.BottomStyle = Style.Border.StyleValue.medium;
diffStyle.CurrentBorder.BottomColor = "bf6262";

workbook.CurrentWorksheet.AddCellRange(data, new Cell.Address(0, idx), new Cell.Address(data.Count - 1, idx), evenStyle);
workbook.CurrentWorksheet.GetCell(2, idx).SetStyle(diffStyle);

from picoxlsx.

Mighty embarrassing... I had a variable mistyped in some supporting code that my breakpoints weren't capturing.

I apologize for wasting your time. Thank you for the repo!

from picoxlsx.

No Problem.
I know that the style section is quite complicated und not very well documented. A rewriting is ongoing since some months. But it will take probably some additional months until it can be released.
Please let me know if you find inconveniences, problems or bugs. Thank you.

from picoxlsx.

So I'm doing this below:

Style style1 = new Style();
style1.CurrentFill.BackgroundColor = "00ff00";
Style style2 = new Style();

And then I write some cells with an explicit style of either default or style1 or style2. The cells I'm expecting to have a colored background, because of style1, do not.

from picoxlsx.