Created attachment 21984 [details] after saving this file some cell references from myfunction are pointing to a different cell If I open and store an xls-file (no changes) with hssf some cell references are moved to a different location. Only cell references from macro functions are affected. I attached an example xls. After saving this file with poi some cell references point at a different cell. Build & Platform poi-3.0.1-FINAL-20070705 on Win XP SP2
There were a few POI bugs that needed fixing here. The initial report "some cell references point at a different cell" is probably a duplicate of bug 41726 (which was fixed before 3.0.2-FINAL. However, since then the LinkTable has been abstracted and it had an assumption that NameRecord(DEFINEDNAME-0x18) would not occur by itself, but only after a SupBook(EXTERNALBOOK-0x1AE) and an ExternalSheet(EXTERNSHEET-0x17) record. The supplied file just has a NameRecord all by itself, and Excel seems to be OK with this. The fix was relatively simple and was applied in svn r659429. There were much worse problems which were fixed separately in bug 45066.