Re: [libreoffice-users] Re: Running a Macro from a form

2014-08-31 Thread Marion Noel Lodge
Hi Allan, With the help of Andrew and Alex, you may have solved your problem by now. But if not, I run lots of SQL commands in my Base applications and I could post the Basic code I use, if that was likely to be of any use to you. Noel -- Noel Lodge lodg...@gmail.com On 29 August 2014 19:32,

Re: [libreoffice-users] Formatting Writer formula bar fields

2014-08-31 Thread Mark Bourne
Chris Cameron wrote: Hi, Often I use Writer's Formula Bar (By hitting F2) to do some math inside my Writer document and have the output displayed. The default formatting for this output is to 2 decimal places, which is often less than I want. So every time I must right click the field, click

Re: [libreoffice-users] Parts of document set to read-only by Writer: how to disable (normal methods not working)?

2014-08-31 Thread Mark Bourne
Vincent Rubiolo wrote: Hello Brian On 08/25/2014 10:28 PM, Brian Barker wrote: One possibility here is that structure of your document is more complex than simply cells of table. Have you perhaps got a table - even if only of a single cell - inside a cell of another table? If so, you may have

Re: [libreoffice-users] Re: [Not to group] Re: files on network shares not opening. Own ones are ok?

2014-08-31 Thread Jim Seymour
On Fri, 29 Aug 2014 16:44:49 +0200 hdv@gmail hdv.ja...@gmail.com wrote: On 2014-08-29 13:59, Tom Davies wrote: Hi :) Hm, but Ubuntu has no troubles with network files. I thought i was on LO 3.5.7 but i might have upgraded. I'm out of the office for a few hours again but could check

Re: [libreoffice-users] Intermittent Calc Issues

2014-08-31 Thread Gregory Forster
Hi, remember me? Got it all fixed. Remember, I was having the problem on a 4 month old HP Probook laptop with Windows 7. The goofy highlighting problem was due to a Windows setting in the control panel, in the ease of access settings, then in my keyboard settings. The random insertion

[libreoffice-users] Calc, =left not working as expected

2014-08-31 Thread IGraham
Hello Could someone tell me whats going on in the spreadsheet i uploaded This is a small part (to demonstrate) of a couple of legacy (by year) spreadsheets Column C contains a 7 cell drop down list with a range to select. these rangers did originally contain a graphic face (seemed like a good

Re: [libreoffice-users] Calc, =left not working as expected

2014-08-31 Thread Brian Barker
At 07:51 31/08/2014 -0700, Graham Lovatt wrote: Could someone tell me what's going on in the spreadsheet i uploaded [...] Altering the original sheets as little as possible i used =LEFT(cell ref,1) This seemed to work, except the values returned aren't seen by vlookup and can not be summed

Re: [libreoffice-users] Re: LO Writer (Linux): Way to do text search in set of documents?

2014-08-31 Thread anne-ology
Maybe it doesn't work in Linux, but LO's 'Find-Replace' works with multiple documents for me; [still with 3.4 ] The only thing that never worked is the 'Find', for some reason ;-) I'll click on that one by mistake at times, only to have the document

[libreoffice-users] Need help with regex in a calc macro

2014-08-31 Thread Jim Byrnes
I have some cells that contain data like: (IBM) Ibm corporation. I need to extract the stock symbol ie IBM. I thought I could use regex to get (IBM) and then strip the parens. So far I have been uable to do so. Usually I can search and find examples of code I can study and modify to suit my

Re: [libreoffice-users] Re: [Not to group] Re: files on network shares not opening. Own ones are ok?

2014-08-31 Thread Steve Edmonds
On 2014-09-01 00:56, Jim Seymour wrote: On Fri, 29 Aug 2014 16:44:49 +0200 hdv@gmail hdv.ja...@gmail.com wrote: On 2014-08-29 13:59, Tom Davies wrote: Hi :) Hm, but Ubuntu has no troubles with network files. I thought i was on LO 3.5.7 but i might have upgraded. I'm out of the office for a

Re: [libreoffice-users] Need help with regex in a calc macro

2014-08-31 Thread Brian Barker
At 12:57 31/08/2014 -0500, Jim Byrnes wrote: I have some cells that contain data like: (IBM) Ibm corporation. I need to extract the stock symbol ie IBM. I thought I could use regex to get (IBM) and then strip the parens. So far I have been unable to do so. [...] myRegex.SearchString =

Re: [libreoffice-users] Re: [Not to group] Re: files on network shares not opening. Own ones are ok?

2014-08-31 Thread Jim Seymour
On Mon, 01 Sep 2014 06:41:44 +1200 Steve Edmonds steve.edmo...@ptglobal.com wrote: [snip] Did you notice the permissions and owner on the server of the older files and newer ones. Did the permissions change when you copied the files. There is also a tick box in optionsGeneral to use LO

[libreoffice-users] Re: Calc, =left not working as expected

2014-08-31 Thread Urmas
IGraham: Altering the original sheets as little as possible i used =LEFT(cell ref,1) This seemed to work, except the values returned aren't seen by vlookup and can not be summed (but can be added) and dont work in a graph SUM function skips text values. Use =LEFT(x)+0 or something like that.

Re: [libreoffice-users] Parts of document set to read-only by Writer: how to disable (normal methods not working)?

2014-08-31 Thread Paul
Just a thought, but wouldn't View | Navigator help here? On a simple test document in Writer, after inserting a table within a table, I see two tables listed in Navigator. They appear under each other, so there is no way to tell that they are nested, but double-clicking on them takes one to the

Re: [libreoffice-users] Re: [Not to group] Re: files on network shares not opening. Own ones are ok?

2014-08-31 Thread Steve Edmonds
On 2014-09-01 06:54, Jim Seymour wrote: On Mon, 01 Sep 2014 06:41:44 +1200 Steve Edmonds steve.edmo...@ptglobal.com wrote: [snip] Did you notice the permissions and owner on the server of the older files and newer ones. Did the permissions change when you copied the files. There is also a

Re: [libreoffice-users] Parts of document set to read-only by Writer: how to disable (normal methods not working)?

2014-08-31 Thread Brian Barker
At 16:00 30/08/2014 -0700, Vincent Rubiolo wrote: Unless you have more suggestions, at this point, I think I will open a bug report so that I can attach the document and people can try things out. Or - as has already been suggested - you could just send it to someone or post it somewhere for

[libreoffice-users] longstanding bugs - what does it take to get them fixed?

2014-08-31 Thread Gary Dale
Probably not every LibreOffice writer user prints mailing lists but I'd have thought that a lot of people do. Yet these bugs don't seem to be getting fixed despite my having reported them several times over the years. Both of them are demonstrated in the attached file, which happens to be a

Re: [libreoffice-users] Re: Running a Macro from a form

2014-08-31 Thread Andrew Douglas Pitonyak
I always assume that it might be useful, which is why any of my documents exist :-) So, by all means, post the code. On 08/31/2014 02:58 AM, Marion Noel Lodge wrote: Hi Allan, With the help of Andrew and Alex, you may have solved your problem by now. But if not, I run lots of SQL commands

[libreoffice-users] Re: longstanding bugs - what does it take to get them fixed?

2014-08-31 Thread Alex Thurgood
Le 01/09/2014 02:25, Gary Dale a écrit : Who do I have to talk to in order to get these bugs addressed? A developer who is prepared either to fix it for free, one who will want money or gifts for doing so, or alternatively a developer who works for a company that offers paid tier 3 support.