Re: [libreoffice-users] Corrupt File! Help!!!

2014-01-13 Thread mcmurchy1917-libreoffice
If you can't find a backup. Try this. You seem to indicate that the corrupted spreadsheet is called "*name name.ods*". If that is what it is called copy the corrupted file to an empty folder/directory. In that folder/directory there should now only contain the file "*name name.ods*" unzip t

Re: [libreoffice-users] Libreoffice 4.1.3.2 slow

2013-11-18 Thread mcmurchy1917-libreoffice
Hi Tom I'm on Linux so the defrag is not an issue for me. If I go back to 4.0.5 speed seems OK. The slowness seems to be more apparent when loading forms in Base. I'll look at the memory. My machine is old I've always been more cpu bound than memory bound. As no one else has replied with th

[libreoffice-users] Libreoffice 4.1.3.2 slow

2013-11-15 Thread mcmurchy1917-libreoffice
I've had a number of problems with Libreoffice 4.1.3.2 as compared with 4.0.5. Specifically it seems to be a lot slower, specifically with displaying dialog boxes and forms. It also seems to be very slugish when trying to resize the main window. Sometimes, it seems to hang when displaying a dia

Re: [libreoffice-users] Working sheet Macro file path

2013-10-30 Thread mcmurchy1917-libreoffice
Heena It might be better to rephrase your question to describe the task you're trying to automate. Iain On Tuesday 29 Oct 2013 14:34:09 Tom Davies wrote: > Hi :) > If you don't know then i doubt anyone else does! It is vaguely possible > but i just doubt it. > > Heena what is your 1st langua

Re: [libreoffice-users] LO Base Sub Forms

2013-10-16 Thread mcmurchy1917-libreoffice
I would suggest you study an application that uses a main and sub form. I used the Business Cards example from http://forum.openoffice.org/en/forum/viewforum.php?f=100 Good luck On Tuesday 15 Oct 2013 14:09:59 Ian Whitfield wrote: > Hi All > > I'm still stuck with LO Base Sub Forms!! I'v

Re: [libreoffice-users] Base & PostgreSQL Transactions

2013-07-19 Thread mcmurchy1917-libreoffice
Have you read this document? http://www.baseprogramming.com/OOBasicDatabaseDev.pdf Iain On Thursday 18 Jul 2013 18:32:01 Don Parris wrote: > On Thu, Jul 18, 2013 at 4:27 PM, Tom Davies wrote: > > Hi :) > > If you are looking for a good guide about Macros then Andrew Pitonyak's > > guide is su

Re: [libreoffice-users] disable "save as" in odt document

2013-06-12 Thread mcmurchy1917-libreoffice
Vieri What i would try is this. No idea whether it would work. 1. Include the name of the document as the property 'Title' in the 'Description' tab of the properties dialog - File -> Properties. I believe this property won't change unless someone deliberately changes it. If this is a problem y

Re: [Solved] Re: [libreoffice-users] "Case" function equivalent in Calc

2013-05-16 Thread mcmurchy1917-libreoffice
Just a quick question. What happens if any of the fields already contains a semi-colon? Iain On Thursday 16 May 2013 10:23:23 Carl Paulsen wrote: > Hi Tom. > > Well, not quite. In my particular case this formula worked. But with > some off-list input from smarter brains than mine, I realize i

Re: [libreoffice-users] gettextfields

2013-05-08 Thread mcmurchy1917-libreoffice
Hi Vieri The form you've created contains a set of controls of which one or more of them are of the "Text box" variety. You may also have other controls on the form such as a "Check Box", "Label" or "Push Button" these latter controls don't have the ability to hold text or edit text so don't

Re: [libreoffice-users] gettextfields

2013-05-08 Thread mcmurchy1917-libreoffice
I've created two "Text Boxes" in a form in a writer document. I can iterate over them like this grabbing the text as I go Sub EnumerateFields oDoc = ThisComponent oDrawPage = oDoc.DrawPage oForm = oDrawPage.Forms.GetByIndex(0) For i = 0 To oForm.getCount()-1

Re: [libreoffice-users] [SOLVED] Using a Button to activate Subform.

2013-04-12 Thread mcmurchy1917-libreoffice
Sounds to me that you may have had the Macro in a different document to your Base application. Iain On Thursday 11 Apr 2013 16:01:52 Ian Whitfield wrote: > Hi All > > As Noel suggested here is the reply I sent to him after we had worked on > the problem for a while off-list ... > > *I have cr

Re: [libreoffice-users] pasting numbers into Calc

2013-04-11 Thread mcmurchy1917-libreoffice
Replace does work for these. Found this on the web many moons ago. How to convert numeric text to number by re-entering everything in one step. Select the cells in question. Apply any number format other than "@" (text) menu:Find&Replace... [More Options...] [X] Current Selection [X] Regular expre

Re: [libreoffice-users] Re: booklet printing problem

2013-03-29 Thread mcmurchy1917-libreoffice
I seem to remember I had a problem with priinting brochures a short while ago from within Libreoffice and I also seem to remember that Adobe Reader was OK, it all started happening after an upgrade of my system, I use Slackware. Changing the print driver in CUPs fixed it for me. Iain On Thur

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-25 Thread mcmurchy1917-libreoffice
I've now dropped the dialog and ProgressBar in favour of the status bar with REM Create a NEW status indicator oBar = document.createStatusIndicator() oBar.start("Started...", rsSUBSCRIBERS.Row() + 3) oBar.Value = 1 ' show progress bar Bar.Text = "Progressing..." Then each time the MailMergeLi

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-25 Thread mcmurchy1917-libreoffice
Hi Andrew I had read the document and had hoped this might have changed. From a professional point of view some customers dictate that a mouse pointer must be changed to a hour glass if an action cannot be completed in a pre-determined amount of time. So anyway, I've done a belts and braces j

Re: [libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-22 Thread mcmurchy1917-libreoffice
Hi Tom Not heard of a "loading bar" before, can you point me in the direction where I can read more. I have considered maybe displaying a dialog would some message i.e. "please wait", maybe even with an embedded ProgressBar if such a thing is available. I have seen some mention of a Uno Toolki

Re: [libreoffice-users] LibreOffice 4 paragraph marks, etc.

2013-03-22 Thread mcmurchy1917-libreoffice
Have a look at the "Alternative Dialog for Find & Replace" extension. Here's a link to it - http://extensions.libreoffice.org/extension-center/alternative-dialog-find- replace-for-writer On Thursday 21 Mar 2013 20:24:17 Paul Schmidt wrote: > My first look at LibreOffice 4.0 impresses me. Look

[libreoffice-users] Changing The Mouse Cursor to an HourGlass

2013-03-21 Thread mcmurchy1917-libreoffice
Hi All I've built a database, using Base, which amongst other things produces a mailing list. On my 10 year old DeskTop it can take several minutes to produce the list. I want to show some activity to the users, so the mouse cursor morphing into an HourGlass would suit me fine. I've got this