Declined
Last Updated: 26 Apr 2023 05:31 by ADMIN
Daniel
Created on: 17 Apr 2023 10:19
Category: Kendo UI for jQuery
Type: Bug Report
0
Vlookup function export to pdf issues

Hi Support Team,

I try to apply VLOOKUP function in demo page.

VLOOKUP  Function:  =VLOOKUP(B8, 'Food Order #1'!B3:F11, 5, true) , the result showing in spreadsheet is $13.19, but when export to PDF the result show in PDF change to $52.16.

Can you please check on this issue.

Thank you

Regards
Daniel

2 comments
ADMIN
Neli
Posted on: 26 Apr 2023 05:30

Hi Daniel,

Thank you very much for your patience.

When the used data is not sorted the fourth parameter in the VLOOKUP formula should be false. This parameter indicates whether an approximate or exact match will be returned and should be set to false when the range is not sorted.  In the current scenario where the data in the targeted range is not sorted using the VLookup with the fourth parameter set to true is not valid. Thus, if you change the formula as follows:

=VLOOKUP(B8, 'Food Order #1'!B3:F11, 5, false)

the result in the exported PDF will be the same as the result in the Spreadsheet. 

I will proceed and will mark the report as 'Declined'.

Please test the formula as described above and let me know in case you have any additional questions or comments.

Regards,
Neli
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

ADMIN
Neli
Posted on: 24 Apr 2023 09:49

Hello Daniel,

Thank you very much for reporting the observed behavior. I will need some more time to review the issue, thus I am changing the status of the item to 'Under review'. 

I will write you back with more information on the matter once I have something to share.

Thank you very much for your patience.

Regards,
Neli
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.