I think it is really cool that you can now have a matrix of conversion formula for each table in your XDF.
The way it appears to work now, is that the cell conversion overrides all other conversions, the column conversion overrides the general, etc.
I think it would be cool if all the conversions were cumulative. In other words, you could have individual cell conversions, but still apply the column conversion on on top of the cell conversion, and then the global conversion on top of everything.
I realize that this doesn't really add any functionality (as you would achieve the same output by just changing all the individual cell conversions), but would result in less typing when you need different cell conversions, and make conversions easier to change in general. The way it is setup right now is a little confusing, because when you apply a cell conversion, the global conversion is still showing, but no longer applies.
Just a thought. Not sure if it's worth working on or not.
Comment on XDF Conversion
Moderators: Mangus, robertisaar, dex
-
- Posts: 17
- Joined: Mon Feb 08, 2010 4:48 pm
Another feature that I would like to see pertains to emulating integer math a little better in the conversion.
It would be great if you implemented both ROUND and FLOOR functions. Usage would be similar to the excel version of these functions - ROUND rounds the number to a specified decimal, and FLOOR truncates a number to a specified decimal.
Also, as mentioned in another thread, there appears to be a problem with the IF function in conversions. I can't seem to get it to work using the operator as a output of the function. IF(X<20;X:X*2) doesn't work.
Thanks for listening to ramblings.
It would be great if you implemented both ROUND and FLOOR functions. Usage would be similar to the excel version of these functions - ROUND rounds the number to a specified decimal, and FLOOR truncates a number to a specified decimal.
Also, as mentioned in another thread, there appears to be a problem with the IF function in conversions. I can't seem to get it to work using the operator as a output of the function. IF(X<20;X:X*2) doesn't work.
Thanks for listening to ramblings.
-
- Posts: 17
- Joined: Mon Feb 08, 2010 4:48 pm