Re: [libreoffice-users] Confused with Macro results??

2020-07-05 Thread Michael D. Setzer II
t;" Months ""),"""")(DATEDIF(" & sText & ",""md""),IF(DATEDIF(" & sText & ",""md"")=1,""1 Day "",DATEDIF(" & sText & " ,""md"")&

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Andrew Pitonyak
ase enter Date Cells Example D2,D1:") rem ------dim args1(0) as new com.sun.star.beans.PropertyValueargs1(0).Name = "StringName"args1(0).Value = "=IF(DATEDIF(" & sText & ",""y""),IF

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Andrew Pitonyak
12)=1,_1 Month _,MOD(DATEDIF(A2,A1,_m_),12)_ Months _),__)IF(DATEDIF(A2,A1,_md_),IF(DATEDIF(A2,A1,_md_)=1,_1 Day _,DATEDIF(A2,A1,_md_)_ Days_),__),A2,A1,chr$(34)sTextchr$(34)),_,CHAR(34)) dispatcher.executeDispatch(document,.uno:EnterString,, 0, args1()) msgbox (To complete process,+chr$(13)+Formula

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Andrew Pitonyak
Might I ask what you want the macro to do? Your macro confuses me a bit...  That said, the actual API has a very harsh learning curve (in my opinion). If I rip apart what I see, I would guess the following:  The user enters some text, which represents a set of cells separated by a comma. 

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Michael D. Setzer II
to press 4 or 6 additional key strokes?? On 5 Jul 2020 at 1:33, Regina Henschel wrote: Subject:Re: [libreoffice-users] Confused with Macro results?? To:users@global.libreoffice.org From:Regina henschelrb.hensc...@t-online.de Date sent:Sun, 5 Jul 2020 01:33:10 +0200 Hi Michael, your post

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Michael D. Setzer II
Subject:Re: [libreoffice-users] Confused with Macro results?? Might I ask what you want the macro to do? Your macro confuses me a bit... That said, the actual API has a very harsh learning curve (in my opinion). If I rip apart what I see, I would guess the following: The user enters some text

[libreoffice-users] Confused with Macro results??

2020-07-04 Thread Michael D. Setzer II
Been doing a lot of googling, but finding lots of stuff, but nothing that works? Have done a lot of versions and this is the latest one. The record process does not allow for the use of the F2 key, so as is, it results in the original args1(0).Value being in the cell? After the macro ends, I've

Re: [libreoffice-users] Confused with Macro results??

2020-07-04 Thread Regina Henschel
Hi Michael, your post is hard to understand. Please write, what you want to achieve with your macro. Kind regards Regina Michael D. Setzer II schrieb am 05-Jul-20 um 00:30: Been doing a lot of googling, but finding lots of stuff, but nothing that works? Have done a lot of versions and this