https://bugs.freedesktop.org/show_bug.cgi?id=50860
--- Comment #2 from davidover...@du-mont.com 2012-06-21 08:04:33 PDT --- The behavior I was dealing with is the same as found in the following forum thread and is apparently the standard behavior for formulas referring to a cell on a different sheet when the sheet is copied. The use of absolute references is an easy resolution, but personally I find the behavior a little counter intuitive. Overall I love calc and have been using it for years at home and have been advocating a change at the company I work for, but things like this make adoption harder to argue for. When long term spreadsheet users find what appear to be problems with basic functions, it scares them off and the odds of getting a second look are slim. I'm not advocating that calc be a clone of excel by any means, as there are some things that I prefer about calc, but some things should behave in the same manner. Please keep up the good work and if there is anything I can do to help (I'm not a programmer) let me know. http://user.services.openoffice.org/en/forum/viewtopic.php?t=47863 <http://user.services.openoffice.org/en/forum/viewtopic.php?t=47863> Steps to reproduce problem: 1) Open attached spreadsheet 2) Copy Sheet 1 to the position after Sheet 2 3) Compare formulas between Sheet 1 and the copy (I expected them to be the same) Thanks, David On 6/21/2012 8:09 AM, bugzilla-dae...@freedesktop.org wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=50860 > > bfoman<bfo.bugm...@spamgourmet.com> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > CC| |bfo.bugm...@spamgourmet.com > > --- Comment #1 from bfoman<bfo.bugm...@spamgourmet.com> 2012-06-21 06:09:38 > PDT --- > Could you attach any example documents to allow others to check on different > system/build? > -- 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs