[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 Xisco Faulí changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |WORKSFORME --- Comment #12 from Xisco Faulí --- (In reply to BRANDT from comment #11) > Sorry to not answered before but i can't reproduce it, i tried many things > but none reproduce the bug. So an update solved it. > > Many thanks, > René. Closing as RESOLVED WORKSFORME then -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #11 from BRANDT --- Sorry to not answered before but i can't reproduce it, i tried many things but none reproduce the bug. So an update solved it. Many thanks, René. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #10 from Xisco Faulí --- (In reply to BRANDT from comment #9) > I will build testbug2 more closer that mine. Testbug was a very simplified > version. Any update ? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #9 from BRANDT --- I will build testbug2 more closer that mine. Testbug was a very simplified version. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904
--- Comment #8 from BRANDT ---
i just see that i loosed the message i entered with the attachments.
so the macro TESTBUG :
Sub TestBug
rem --
rem Macro used to test the automatic backup bug
rem --
dim answ1, answ2, answ3, answ4 as string
answ1 = inputbox("1st line")
answ2 = inputbox("Number of lines to insert ?")
answ3 = inputbox("Number of times for the loop ?")
answ4 = inputbox("number of lines to skip ?")
rem define variables
dim document as object
dim dispatcher as object
rem --
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
dim args0(0) as new com.sun.star.beans.PropertyValue
args0(0).Name = "Nr"
args0(0).Value = 1
dispatcher.executeDispatch(document, ".§", "", 0, args0())
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ToPoint"
rem access to first cell to get the start value
osheets = Thiscomponent.getSheets()
osheet = osheets.getByIndex(0)
ocell1 = osheet.getCellByPosition(0, 0)
Lcell = ocell1.getValue()
nu1 = val(answ1) rem line to start
nu2 = val(answ2) rem number of lines to insert
nu3 = val(answ3) rem number of times we loop to insert lines
nu4 = val(answ4) rem how many lines we skip before next insert
for j = 1 to nu3
args1(0).Value = "$A$" & Cint(nu1)
dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())
dispatcher.executeDispatch(document, ".uno:InsertRows", "", 0, Array())
for i = 1 to nu2 - 1
dispatcher.executeDispatch(document, ".uno:Repeat", "", 0, Array())
next i
nu1 = nu1 + nu2
ocell1 = osheet.getCellByPosition(0, nu1)
Lcell = Lcell + 1
ocell1.Value = Lcell
nu1 = nu1 + nu4 rem skip nu4 lines
next j
end sub
this macro ask four things :
1 - on which line we start
2 - how many lines we insert
3 - how many times we loop on the inserts
4 - how many lines we skip before next insert
I run it with start on line 2, insert 2 lines, loop 1500 times and skip 3
lines,
that gives image before and after the execution.
I tryed but can't reproduce the bug.
René.
--
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #7 from BRANDT --- TestBug was a too simplified version of mine. I will build another version more closer to mine. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #6 from BRANDT --- Created attachment 144610 --> https://bugs.documentfoundation.org/attachment.cgi?id=144610&action=edit image after macro execution -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #5 from BRANDT --- Created attachment 144609 --> https://bugs.documentfoundation.org/attachment.cgi?id=144609&action=edit image before macro execution -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #4 from BRANDT --- Created attachment 144608 --> https://bugs.documentfoundation.org/attachment.cgi?id=144608&action=edit file for testing -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #3 from Xisco Faulí --- Please do, thanks! -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 --- Comment #2 from BRANDT --- Hi, I will build you a macro to run a produce the bug because mine is too complicate to use and explain to obtain the bug. I will come soon. René -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO CC||xiscofa...@libreoffice.org Ever confirmed|0 |1 --- Comment #1 from Xisco Faulí --- Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 118904] automatic backup during macro execution
https://bugs.documentfoundation.org/show_bug.cgi?id=118904 rob...@familiegrosskopf.de changed: What|Removed |Added Component|Base|BASIC -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
