https://bugs.freedesktop.org/show_bug.cgi?id=50860
--- Comment #4 from lucy <[email protected]> 2012-09-12 07:35:25 UTC --- I have same problem -using version 3.5.6.2 (on Windows 7) Producing summary sheets referenced to data in 16 sheets. Arranging summary data from each sheet in rows - in the same order as sheets in file. The row order of the references become jumbled randomly but the references within the row remain the same and rest of data copies correctly (including formulas with in the rows) A problem because in my case the rows are then labelled as containing data from another sheet -just glad I realised it had happened. Copy sheet next to original works, copy in another sheet position references become jumbled. Repeated copying in same position maintains the same jumbled order, copying into another sheet position jumbles reference but in a different order. My sheet references have format =sheetname.$C$122 - changing to =$sheetname.$C$122 stops the jumbling but shift F4 does seem to add the $ to the sheet name and if this is required it should happen when you are linking to another a sheet... (sorry can't upload file as it contains personal client info) -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
