Posted 8 September 2017, 1:18 pm EST
I have sheets(0) with a bunch of formulae that work fine. However, I need to import an Excel page 1 to sheets(1) to do some data manipulation.
I used the OpenExcel method to import the Excel file like this:
The import works fine. But now all the formula on sheets(0) are no longer working! This is a show-stopper for me.
Did I miss something here? Is there a work-around to make the formulae work again?
I have attached a test project to demonstrate the behavior. I am using the FpSpread version 4.0.2001.2005
Another note: I also experienced some Excel macros that do not behave normally after using OpenExcel method when I do the Excel.Run("macro"). I would get Excel alerts that requires comfirmation that I would not normally get. But those I can turn them off, fortunately.
2008/06/Testing OpenExcel bug.zip