Conditional formats in xlsx files

Hi,

we would like to use Excel based conditional formats in xlsx files while generating a report via FlexcelReport. But unfortunately the conditional formats are missing after report creation. We are using version 6.2.1. I have read the release notes from the newer releases, but I could not find any entries that address this issue. Is the conditional format support on your roadmap and/or can you tell me in which version it will be released?

Thanks in advance

Hi,

Support for conditional format in xlsx is scheduled for next release: 6.7. We don't have a timeframe yet on when it will be ready, but it should be in the coming months, I hope by the end of this one. Not sure if we are going to make it for the end of november, but we are trying.

Xlsx cond fmt is our top priority right now, and we are working as fast as we can to have it ready. But it is a complex task, which includes formatting the cells when exporting to pdf/html too, and lots of new stuff introduced in Excel 2007. We've already finished a good part of the support, including drawing all the icon sets (and differently from Excel, we draw them vectorial, not as bitmap, so they look well at any resolution and zoom). 

At the moment, support is only for xls/2003 style conditional formats, and we include support also when exporting to pdf/html/etc. Once 6.7 is out, there should be full support for xlsx too.

OK, thank you for the answer.

Hello,

do you already have a realease date for version 6.7?

We are having some performance problems in the conditional format rendering, we still need to optimize the code more. This is why it is still delayed, we want to release it when it is not just only working, but working correctly and fast.


 We released 6.6.19 yesterday because other improvements have been piling up in the last months, and we don't want the people who care about those to have to wait until we finish the cf support to get them. As soon as cfs are working correctly we'll release 6.7.

I am also interested in seeing version 6.7 for Conditional Format Support.

I saw that you just recently released version 6.7 . But I can find no entry in the release notes concerning conditional formats. Are they now preserved in version 6.7?

I am really sorry about this, but it didn't made it for this release, and had to be pushed back for 6.8. We had to release a new FlexCel version now, to support both Delphi 10 in FlexCel for VCL and VS2015 in FlexCel for .NET. So we just shipped what was ready and tested at this moment for users to be able to install in the new IDEs. 


Conditional format is working internally but we had to pull the code in order to release, because there were many bugs still to fix on it. We'll keep working on it (this and 2007 tables support are really the only 2 important things missing in our xlsx support) and we will release it as soon as it is ready. The feature will be the first in the what's new, so it will be easy to spot.

I really wish I had better news, but it seems like there is always something getting in the way to finish them. At this time, I think nobody wants to see the full cf support for xlsx more than me.

OK, thank you for your answer. Do you have any estimated release date for the conditional formats? I am asking because we have several requests from our customers and it would be nice if we could get at least an estimated date.

I really think it should be ready by the end of october. The thing is, we are already very delayed (as you know) so I don't really feel comfortable giving you an estimate that I am not sure is right. But most of the work has been done, we just need to connect the parts, do a lot of testing and release. 

Ok, thank you for your information.

Hello Adrian,

it seems that the conditional format support is still missing. I don't want to annoy you with this topic but we have a customer request concerning conditional formatting and I just would like to know if there will be conditional formatting available by the end of january?

I really hope so. To be completely honest, I was hoping to have it already, since december is normally a quiet month. But this year support seems to not only have not decreased but increased. I hope the next part of december will be more calm and allow me to write the small pieces still missing.

Hello Adrian,


Wondering if you were productive on this issue over December and early January?

Thanks!

Jason

For what is worth, December didn't slow down. I was answering support emails in dec 24 and dec 31. We released 6.7.3 in january 2016 with all the things we had to add due to all the requests. The only positive thing is that from about 3 days ago support did slow down and we progressed a little. It seems that today I am back answering posts/emails, hoping it is only today and after finishing with this batch of replies I can go back to coding.

Hi Adrian,

nothing has been mentioned about conditional formats in xlsx files for version 6.7.8.0. Any update on this?

Andreas

Hi,

The version which will include conditional formats will be 6.8. All the 6.7.x versions are bugfixes releases with all the accumulated stuff that has been going in parallel with the cond fmt development the latest months. There is no sense in not keeping those bugfixes  unreleased until 6.8 is ready.

Hi Adrian,

ok, understood, that the conditional formats will be available with version 6.8 was new to me.

I'll wait for version 6.8 then.

Andreas

Hi Adrian, I downloaded v6.8, but conditional formatting doesn,t work in xlsx files if i used a template file.

Paolo

Hi,
Sorry about that.

Xlsx Conditional format is in final testing right now, it should be out in a couple of weeks now. What just happened is that we had to release a 6.8 version to support Delphi "berlin" in the Delphi Side, and UWP10 in the .net side. We couldn't wait until cf support was stable to release it, as much as I would have liked to, as we were having many requests, both for Berlin and for UWP10. So we released 6.8 with that an a lot of other stuff, and rescheduled for 6.9.

Again, I am really sorry to say this, and I hope we can finish this soon. I've been through a perfect storm of lots of unrelated feature/bug fixes requests, personal issues and issues finding a way to have conditional formats perform well enough in xls and xlsx. (because in our first implementation, we added xlsx support but made the xls support much slower, and we couldn't do that so we had to go back to the start). Well, I am going back to working on the conditional formats now.