New Publisher in Report ID 81 (Import Budget from Excel) & Report ID 82 (Export Budget to Excel)

[KerstinBrokerhoffGOB]

Why do you need this change?

I need these publisher to realize a customer request.
I would like to avoid having to copy and adapt the standard report and having to check it again with every update.

Describe the request

Hello,
I need new publisher in Report ID 81 (Import Budget from Excel) to realize a customer request.

In the function ÔÇ£AnalzyeDataÔÇØ in the ÔÇ£case TempExcelBuf.Comment ofÔÇØ I need new publishers for the case ÔÇ£Text014ÔÇØ.
It would be a great support if there was an OnBeforeInsertBudgetBuf(var BudgetBuf, IsHandled) at this marked position:

It would also be helpful if there was an OnAfterCaseText014(var BudgetBuf) publisher at the end at this position:

I also need Publisher in the EnterCell function for the standard report ID 82 (Export Budget to Excel).
Here it would be very helpful if there was a Publisher OnBeforeInsertTempExcelBuff(var TempExcelBuf) [perhaps it would make sense to include the CellValue in the Publisher as well!?] before the insert.

In one of my customer projects, a separate CellValue is to be written to the Excel file and I am currently unable to implement this requirement because publishers are missing in the relevant places.

Thank you in advance for your help.
Internal work item: AB#592755

[KerstinBrokerhoffGOB]

Hallo Alexander Yakunin (@Alexander-Ya) , could you please let me know when a new status can be expected here? Thanks a lot in advance. Kerstin Hielscher (formerly Brokerhoff).

[KerstinBrokerhoffGOB]

Hello again Alexander Yakunin (@Alexander-Ya) , it would be very helpful if you could please assign a new status here so that we can update the customer project accordingly. Could you let me know when I can expect a new status? Kind regards, Kerstin Hielscher (formerly Brokerhoff).

[GOB-Andrea]

Hello all,

the first of the two publishers has been added. Thank you very much!
The second one is still missing. Here for a quick copy+paste:

Report 82 "Export Budget to Excel"

local procedure EnterCell(RowNo: Integer; ColumnNo: Integer; CellValue: Text[250]; Bold: Boolean; UnderLine: Boolean; NumberFormat: Text[30]; CellType: Option)
    begin
        TempExcelBuf.Init();
        TempExcelBuf.Validate("Row No.", RowNo);
        TempExcelBuf.Validate("Column No.", ColumnNo);
        TempExcelBuf."Cell Value as Text" := CellValue;
        TempExcelBuf.Formula := '';
        TempExcelBuf.Bold := Bold;
        TempExcelBuf.Underline := UnderLine;
        TempExcelBuf.NumberFormat := NumberFormat;
        TempExcelBuf."Cell Type" := CellType;
        // START NEW
        OnBeforeInsertTempExcelBufferOnEnterCell(TempExcelBuf);
        // END NEW
        TempExcelBuf.Insert();
    end;

// START NEW
[IntegrationEvent(false, false)]
local procedure OnBeforeInsertTempExcelBufferOnEnterCell(var TempExcelBuffer: Record "Excel Buffer" temporary)
begin
end;
// END NEW

Alexander Yakunin (@Alexander-Ya) Could you please check the status of the second publisher? Do you need any further information?
KerstinBrokerhoffGOB FYI

[AleksandricMarko]

Thanks for reporting this. We agree, and we’ll publish a fix asap, either in an update for the current version or in the next major release. Please do not reply to this, as we do not monitor closed issues. If you have follow-up questions or requests, please create a new issue where you reference this one.