Hi,
We are using DevExpress VCL components V14.2.3 and Delphi XE2 ide.
The question is about the SpreadSheet component.
We want to reproduce Excel behavior when using IF function on an empty cell :
=IF(ResultMois!B3=0;"";INDIRECT("Divers!O"&WEEKDAY(ResultMois!B3)))
Using Excel an empty cell or containing 0 will return TRUE
Using DevExpress SpreadSheet it will return TRUE if the cell contains 0, but FALSE when the cell is empty.
We cannot change the formula because it’s legacy code, and the SpreadSheets are shared through multiple existing applications.
So, how can we obtain the same behavior as Excel ?
Xavier PATOIT
Software Engineer
Bally Technologies
Hello Xavier,
I've reproduced this behavior and forwarded this ticket to our developers for further processing.
Hi Mikhail,
Thank you for your quick answer.
We will greatly appreciate a quick solution too because it's a big project for us, mainly depending on this component.
Xavier
Hi Mikhail,
Any news for the ticket ?
Can you confirm it's been processed ?
Xavier
Our developers are working on this request. I am afraid we cannot give you a precise time frame as to when this functionality will be fixed. We appreciate your patience and understanding.
Ok Mikhail, thanks
Xavier
Xavier, we've fixed this behavior with an empty cell, however, this fix is very complex (there are changes in a lot of units) and we cannot provide it to you. I however believe we will release the new version of our controls (VCL 14.2.5) early in April (in one or two weeks).
Also, I need to note that the INDIRECT function is not supported by our new SpreadSheet and I've created a separate suggestion about implementing it in future versions - T224612: TdxSpreadSheet - implement an INDIRECT function like in Excel.
Excellent Mikhail,
For sure we are really interessed in having your best suggestions for INDIRECT implementation.
Xavier