https://bugs.documentfoundation.org/show_bug.cgi?id=97193
Bug ID: 97193 Summary: macro to copy/paste using dispatchhelper not working correctly(or as it did previously) Product: LibreOffice Version: 5.1.0.1 rc Hardware: x86-64 (AMD64) OS: Linux (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: pherwo...@gmail.com Created attachment 122009 --> https://bugs.documentfoundation.org/attachment.cgi?id=122009&action=edit a portion of a longer macro that actually works the copy/paste I have a macro in basic to copy data (inc some formulae) which changes each month in one sheet to the end of another sheet in the same document. I attach the appropriate portion of the code. Variables are all set up outside this portion correctly and the 'findend' is my own function to return the number of the first availble empty cell in col A. This also still works correctly. I have 2 MsgBox entries - the first is a safety measure in case the wrong button is clicked - the second I just inserted to check that the correct range for paste is being selected (and it is). Right from old ooo to lo 5.0.2 this has worked. What happens now is that the "uno.insertcontents" instructions appends the data exactly where it should be (say, A300:E316) but then moves all the data above this to the right by the 5 columns (ie F1:M299). This should obviously all remain as A1:G299. (There are 3 extra columns not applying to the new data yet). Other code I have eg to insert a row of new data using the "findend" function works as it should. I assume it's either the "Frame" or the actual "uno.insert..." going wrong. -- 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