Dev build 230526

[stan]

I've uploaded a new dev build with a minor improvement - when exporting tables to MS Excel there's a new option to include cell background colors (hot/cold numbers, row selection, etc)

[dreamweaver]

Hi Stan,

Firstly I would like to thank you for a significant improvement and enhancement to the way users can evaluate EL5 data output in a
spreadsheet environment.

Most output Scenarios/Tables at this stage seem to enable you to copy the background colours of data within those Tables. However
I have found that when I created a PAIRS Table from a Winning Number Analysis the background colours do not seem to be included
when data has been exported.


Thanks and Regards

[stan]

Thanks for letting me know, I'll look into that.

[stan]

So the problem with Pairs table is that there can be two different background colors in each cell. But I can't set two different background colors in MS Excell cell. I'm afraid I can't fix this.

[dreamweaver]

Hi Stan,

Once again thank you for looking into this issue...

I was thinking more so the colours could be set if there is a fixed set of pairs
that have been selected via the "Number Coloring" option.

In this the selected pairs are "locked" in and their coloration remains one color,
as per example below:

Pairs Coloration.JPG

Thanks and Regards

[stan]

Unfortunately it's not possible either. The backgrounds of pairs and triplets are painted in a special way so the table exporter can't retrieve that color easily.

[dreamweaver]

Sorry the late reply..

Once you have exported into Excel you can create some VB code to color those outcomes according to a criteria.

Thanks Stan

[stan]

Well, I don't know how paint multi-colored background in a single cell in Excel so that doesn't seem very feasible to me.