Has anyone else noticed that cell references in Named Ranges are no longer being saved in v4.1.0? If so, is there a fix?
Hi hrothgar,
I can not reproduce the issue with Win7x64
Version: 4.1.1.0.0+ Build ID: c1f0f890f5065f88164add33707228f8c6d5755
TinderBox: Win-x86@6-debug, Branch:libreoffice-4-1, Time: 2013-07-28_23:51:08
With file types: ods, xls, xlsx.
Have you trying resetting the user profile?.
Edit 2013-08-02
GETPIVOTDATA() works for me with:
Version: 4.1.1.0.0+ Build ID: c1f0f890f5065f88164add33707228f8c6d5755
TinderBox: Win-x86@6-debug, Branch:libreoffice-4-1, Time: 2013-07-28_23:51:08
I have had reported a bug fdo#66655 about GETPIVOTDATA() issue, which is solved now.
Hello mariosv,
Thanks for your suggestion. I’ve tried rebuilding the profile, and then opening existing files and a new spreadsheet, but the problem still persists. The GETPIVOTDATA function isn’t working either, just producing a #REF! error. I can work around these problems, but it’s a bit odd! (VLOOKUP, for instance, works fine.)
I’m using Win7x64, and LO version Version: 4.1.0.4 Build ID: 89ea49ddacd9aa532507cbf852f2bb22b1ace28