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
