Page 1 of 1
Dev build 230526
Posted:
Fri May 26, 2023 9:22 pm
by 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)
Re: Dev build 230526
Posted:
Sat May 27, 2023 4:14 am
by 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
Re: Dev build 230526
Posted:
Sat May 27, 2023 10:36 am
by stan
Thanks for letting me know, I'll look into that.
Re: Dev build 230526
Posted:
Sat Jun 03, 2023 11:48 am
by 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.
Re: Dev build 230526
Posted:
Tue Jun 13, 2023 12:59 am
by 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
Re: Dev build 230526
Posted:
Fri Jun 16, 2023 9:45 pm
by 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.
Re: Dev build 230526
Posted:
Wed Jun 28, 2023 7:56 am
by 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
Re: Dev build 230526
Posted:
Sun Aug 27, 2023 3:28 pm
by 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.