Tony Q.

Looks your company is using NPOI. Can you contribue your use case to https://github.com/nissl-lab/npoi/issues/705 ?

https://bz.apache.org/bugzilla/show_bug.cgi?id=46664

I can almost confirm the issue is caused by ptgClass. ptgClass equals CLASS_VALUE (32) instead of CLASS_REF(0). The correct value should be 3B instead of 5B. https://github.com/nissl-lab/npoi/blob/b207777878dfb63fa1500764bb1bd1c049cf4d23/main/SS/Formula/PTG/Area3DPtg.cs#L84

Is it possible that you switch to xlsx (XSSFWorkbook)?

I don't think BITOR is supported at all. NPOI simulates the Excel formula engine instead of using the original Excel engine. That's why NPOI doesn't have any dependency on Excel...

Thank you for reaching me. I'll evaluate the breaking change in .NET 6.

@ligg Can you help on this? We need an alternative library to make it work.

@safern Do you have any suggestion about alternative to System.Drawing.Common on Linux?

https://docs.microsoft.com/en-us/dotnet/core/compatibility/core-libraries/6.0/system-drawing-common-windows-only

#760