Re: [libreoffice-users] Macro/button to update link(s) to external sheet(s)

2017-01-16 Thread Cley Faye
Ok, I can't test this right now, but this page might have an acceptable answer: http://blog.louic.nl/?p=622 The part about adding a nice button have a small macro in it. Here it's used for linked CSV files, but since the dialog asking to update links that's shown when you reload your file is the

[libreoffice-users] Macro/button to update link(s) to external sheet(s)

2017-01-16 Thread Tanstaafl
Ok, one more hurdle... I tried recording a macro to do this, but it just opens the Edit > Links window, it doesn't finish (update the links and close the window). Anyone have any ideas on how to accomplish this? I really don't want to tell the boss he'll have to do that manually every time he

Re: [libreoffice-users] Calc - blank cell not treated as 0 in formula when referenced from external file/sheet

2017-01-16 Thread Tanstaafl
Anyone? This one is going to be a real problem if I can't solve it. Thanks On Fri Jan 13 2017 08:53:29 GMT-0500 (Eastern Standard Time), Tanstaafl wrote: > Hello, > > Before I go open a bug for this, would appreciate if someone could confirm. > > Using 5.2.3 on

[libreoffice-users] Macro/button that allows sorting and hiding/unhiding on protected sheet?

2017-01-16 Thread Tanstaafl
Hello all, I am not a programmer, but I'm trying to add a few buttons to a worksheet that will allow the boss to do a few things on a protected sheet that you normally can't do without unprotecting it. Is it possible to create a macro that can, for example, hide/unhide (so it would be a toggle

Re: [libreoffice-users] Calculating MONTHNAME

2017-01-16 Thread Tanstaafl
Worked perfectly, thanks Tony! On Fri Jan 13 2017 15:15:15 GMT-0500 (Eastern Standard Time), Tony Arnold wrote: > Try =text(now(),"MMM") > > Tony. > On Fri, 2017-01-13 at 15:05 -0500, Tanstaafl wrote: > > Ok, this is really driving me nuts... > > Given: > >

Re: [libreoffice-users] LibO 5.3 Table Styles

2017-01-16 Thread Ricardo
El 2017-01-16 12:34, toki escribió: All: Libre Office Version: Version: 5.3.0.1 Build ID: 3b800451b1d0c48045de03b5b3c7bbbac87f20d9 CPU Threads: 2; OS Version: Linux 4.7; UI Render: default; VCL: gtk2; Layout Engine: new; Locale: en-ZA (en_US.UTF-8); Calc: group In _Styles and Formatting_, go