15

There is a problem when exporting the budget to Excel (Report 82). The report exports formulas to Excel and then calculates them. It seems that the field has a limited number of characters, so then in the case of longer formulas, the export results in an uncalculated value for those accounts in Excel.

The problem is in the code (Table 370 Excel Buffer), it has a limited sum element to 1000 characters.

Long Formula is concatenation of Formula + Formula2 + Formula3 + Formula, 4 table fields (so 4 x 250 characters = 1000 characters). This is legacy limitation that was enough for older versions of Excel.

 


STATUS DETAILS
New