export to excel with display issue

[Yaxin]

I have a report that has three columns added using if, text, dbrw formulas, the report display fine on apliqo, but when I export out and open up, those columns with formula won’t display properly without me making edits. attach is the screenshot of the exported report. Column G, H, I are the columns with display issue. G and H uses if, text, len, dbrw formulas and I found those two columns are exported out with the formula attached, when I connect to server through PAx, those two columns show #VALUE!, I’ve made changes to column H dbrw formula for it to show up since the dbrw in excel constructs a bit different than apliqo, column I uses dbrw only and it doesn’t exported out with formula attached, I had to change format type on excel from “General” to “Text” in order for it to display properly. Is this a bug for the apliqo version 2023.10 FP2 or there is setting I can do on the server end?

1. I don’t think it should export the actual formula into excel
2. I shouldn’t need to do any format changes on excel for it to show up

‌

[Ada Trajer]

Hi Yaxin, I sent you an email describing the options that should help with this issue.