Forum Discussion

Copper Contributor

Sep 27, 2023

Solved

Problem ExcelScript in excel files with compatibility mode 97-2003

I don't really know if this is the problem, but after many times of trying to run the most simple lines of code in Excel Typescript, function main(workbook: ExcelScript.Workbook) { const shee...

developer

Office Scripts

JKPieterse
Sep 27, 2023
LearnExcelScript I hoped to find an answer here:
https://learn.microsoft.com/en-us/office/dev/scripts/testing/platform-limits
but it does not mention the Excel file type.

SergeiBaklan

Diamond Contributor

Sep 27, 2023

MichelleRanMSFT

I was able to reproduce it (client is current Beta)

Above file is attached.

test script compatibility.xls21 KB

MichelleRanMSFT

Microsoft

Sep 27, 2023

Ah, I see - there does indeed appear to be a bug with the getUsedRange API when run on workbooks in compatibility mode. We've logged a bug with the relevant team, although we don't have a timeline to share at the moment. Thanks for reporting this!

SergeiBaklan
Diamond Contributor
Sep 27, 2023
MichelleRanMSFT Hope you fix it sooner or later, thanks.