Re: [libreoffice-users] [macros] How to create a timer ?

[Mauricio Baeza Servin]

On Fri, 21 Jul 2017 22:54:08 +0200, Jean-Francois Nifenecker 
 wrote:

> Maurizio, Andrew,
> 
> thanks for the pointers you posted. This will help me finding out.
> I guess the "simplest" way would be to call a Python script from Basic.
> 
> Thanks again to both of you. You've put me on the way.
> Greetings from the other side of the pond,
> -- 
> Jean-Francois Nifenecker, Bordeaux
> 

Hello again...

Yes, for call Python script from Basic, EasyDev it's your friend: 
http://easydev.readthedocs.io/en/latest/tools.html#call-macros

If you need some special functionality, I can add to EasyDev.

Best regards
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [macros] How to create a timer ?

[Jean-Francois Nifenecker]

Maurizio, Andrew,

thanks for the pointers you posted. This will help me finding out.
I guess the "simplest" way would be to call a Python script from Basic.

Thanks again to both of you. You've put me on the way.
Greetings from the other side of the pond,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [macros] How to create a timer ?

[Andrew Pitonyak]

On 2017-07-21 11:30, Jean-Francois Nifenecker wrote:

All,

I'm looking for a way to create a timer in LibO Basic as a reminder
to accomplish some task.


The timer would be started when the document is opened, then would
send a message to the user if he has not accomplished a particular
task (eg validating a particular dialog) when a delay expires (eg 2
hrs).

In fact I'm in need of several timers for the same document to handle
as many different delays/tasks.


Can anyone point me to some direction as I'm currently in the dark?


Thanks in advance.
Best regards,
--
Jean-Francois Nifenecker, Bordeaux



My gut reaction is that this is not directly supported in Basic.

That said, read these posts:

https://forum.openoffice.org/en/forum/viewtopic.php?f=44=59369

https://forum.openoffice.org/en/forum/viewtopic.php?f=9=33935

Sadly, this post references something implemented in BeanShell that 
would have helped, but it references a now defunct forum with the 
solution (so when they say that MS777 developed a solution and provides 
a link, that link is no longer valid).


http://ooo-forums.apache.org/en/forum/viewtopic.php?t=65864=292463




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: LibreOffice Base crashes unexpected

[Girvin Herr]

On 07/21/2017 08:36 AM, Alexander Thurgood wrote:

Le 21/07/2017 à 16:55, Lumaja a écrit :


Check your kernel version and the Ubuntu Launchpad bug report :

https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772

and also:

https://bugs.documentfoundation.org/show_bug.cgi?id=108619



Alex





Greetings,
I can confirm this bug on Slackware too, with the 4.4.75 kernel security 
update. I had a thread going here a few weeks ago asking for help on 
this problem. My solution was to back out the 4.4.75 kernel upgrade and 
go back to the 4.4.38 kernel. That fixed my problem.


Girvin



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] [macros] How to create a timer ?

[Mauricio Baeza Servin]

On Fri, 21 Jul 2017 17:30:26 +0200, Jean-Francois Nifenecker 
 wrote:

> All,
> 
> I'm looking for a way to create a timer in LibO Basic as a reminder to 
> accomplish some task.
> 
> 
> The timer would be started when the document is opened, then would send 
> a message to the user if he has not accomplished a particular task (eg 
> validating a particular dialog) when a delay expires (eg 2 hrs).
> 
> In fact I'm in need of several timers for the same document to handle as 
> many different delays/tasks.
> 
> 
> Can anyone point me to some direction as I'm currently in the dark?
> 
> 
> Thanks in advance.
> Best regards,
> -- 
> Jean-Francois Nifenecker, Bordeaux
> 


Hi...

You can used EasyDev: http://easydev.readthedocs.io/en/latest/tools.html#timer

Best regards
-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LibreOffice Base crashes unexpected

[Alexander Thurgood]

Le 21/07/2017 à 16:55, Lumaja a écrit :


Check your kernel version and the Ubuntu Launchpad bug report :

https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1699772

and also:

https://bugs.documentfoundation.org/show_bug.cgi?id=108619



Alex




-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] [macros] How to create a timer ?

[Jean-Francois Nifenecker]

All,

I'm looking for a way to create a timer in LibO Basic as a reminder to 
accomplish some task.



The timer would be started when the document is opened, then would send 
a message to the user if he has not accomplished a particular task (eg 
validating a particular dialog) when a delay expires (eg 2 hrs).


In fact I'm in need of several timers for the same document to handle as 
many different delays/tasks.



Can anyone point me to some direction as I'm currently in the dark?


Thanks in advance.
Best regards,
--
Jean-Francois Nifenecker, Bordeaux


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LibreOffice Base crashes unexpected

[Lumaja]

Ubuntu 16.04 LTS
LibreOffice Base
Start with LibreOffice Base ver. 5.1.6.2
Start LibreOffice Base Create new Database > Finish page opens to save the
file name Click on Save and  LibreOffice Base Crashes.
Tried various online suggestions but nothing worked, I now install the
latest LO ver. 5.3.4.2
but Base still crash after saving the new Database name.

Can some one help to Correct this.
Thank you



--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Base-crashes-unexpected-tp4218684.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] no option for layout toolbaar

[oma]

 Hi, in my View menu there is no Toolbar Layout submenu so i can not try out
the Muffin/ribbon. It can be found though in calc, but not in writer. Any
ideas how to restore that? i'm using LO 5.3.4 on windows 10



--
View this message in context: 
http://nabble.documentfoundation.org/no-option-for-layout-toolbaar-tp4218678.html
Sent from the Users mailing list archive at Nabble.com.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] SDW file format specification

[Shinnok]

Marcin,

There's a odf2john.py in JtR Jumbo available. Though it might be outdated:
https://github.com/magnumripper/JohnTheRipper/blob/bleeding-jumbo/run/odf2john.py
 


Last I know, even Johnny was capable of importing ODF and creating a john 
session:
https://github.com/shinnok/johnny/ 

If you get around to adjusting the script to StarOffice or current ODF format 
please also submit a PR to JtR/Johnny. Let me know.

Regards,
Shinnok

> On Jul 19, 2017, at 4:02 PM, Marcin Trendota  wrote:
> 
> Hello
> 
> I'm looking a way to crack my old password-protected StarOffice files. I
> was able to load unprotected files with old OpenOffice (as LO doesn't
> support it anymore), but i can't remember the password(s) for protected
> ones. I would like to feed John The Ripper with password hashes taken
> from these files. Is there any way to obtain them?
> 
> Thanks!
> -- 
> Over And Out
> MoonWolf
> 
> -- 
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? 
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be deleted


-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Help with VLOOKUP requested

[Budge]

I have a formula VLOOKUP(E2,Sheet2.A2:B690,2,0) in cell J2 which fills 
in J2 with the value corresponding to the number in E2 which is looked 
up from a table in sheet2.


My problem is that when I copy this formula down column J the E2 changes 
to E3 which is correct, but the table defined by Sheet2.A2:B690, which 
should be fixed, has the addresses changed also.


How may I fix the lookup table when I copy the file down a column please?

---
This email has been checked for viruses by AVG.
http://www.avg.com


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Help please with VLOOKUP formula

[Budge]

On 21/07/17 11:32, Budge wrote:
I am using a formula to fill in a cell.  The formula is in cell J2 
=VLOOKUP(E2,Sheet2.A2:B690,2,0).


This is looks up the value from E2 in the column 1 of the table on sheet 
2 defined by corners A2:B690, takes the corresponding value from column 
2 of the table and enters it into cell J2.


I want to repeat this formula down the column J but when I copy, not 
only does the reference cell change ie E2 becomes E3 which is correct, 
but the table cell definition also changes, which is not correct.


How should I write the formula to have the table fixed whilst lookup 
cell changes please?



Sorry, I have it now.  Forgot the .
Duh.

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Help please with VLOOKUP formula

[Budge]

I am using a formula to fill in a cell.  The formula is in cell J2 
=VLOOKUP(E2,Sheet2.A2:B690,2,0).


This is looks up the value from E2 in the column 1 of the table on sheet 
2 defined by corners A2:B690, takes the corresponding value from column 
2 of the table and enters it into cell J2.


I want to repeat this formula down the column J but when I copy, not 
only does the reference cell change ie E2 becomes E3 which is correct, 
but the table cell definition also changes, which is not correct.


How should I write the formula to have the table fixed whilst lookup 
cell changes please?


Budgie

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted