Re: [libreoffice-users] Awkward behaviour of LO Calc

2016-03-30 Thread Alex McMurchy
Unless I'm misremembering my maths -2² would be +4 and -(2²) would be -4 So in my mind no bug. Alex On 29/03/16 09:38, lorieul wrote: Hello to all, I have found a fancy behavior of Calc but I cannot decide whether it is a bug or a "feature". Hence I was looking for your advice before posting

Re: [libreoffice-users] Re: base + mailmerge difficulty

2015-07-01 Thread Alex McMurchy
& strStudentID & ".pdf") oNewDocument.storetoUrl(sURL,aProps()) oNewDocument.close(true) End If If TextElement.supportsService("com.sun.star.text.Paragraph") Then REM Ignore Paragraphs End If

Re: [libreoffice-users] Re: base + mailmerge difficulty

2015-06-28 Thread Alex McMurchy
If that's still a problem edit the report to insert a page break before "Schedule for". Alex On 28/06/15 10:16, Alex McMurchy wrote: A proper report should work. Though I seem to remember some problem about getting page throws in the right place. Alex On 28/06/15 00:10,

Re: [libreoffice-users] Re: base + mailmerge difficulty

2015-06-28 Thread Alex McMurchy
A proper report should work. Though I seem to remember some problem about getting page throws in the right place. Alex On 28/06/15 00:10, Gabriele Ponzo wrote: Mail merge is a Writer feature, but also Base reports rely on Writer! So I guess for both cases it's just about arranging a proper re

Re: [libreoffice-users] base + mailmerge difficulty

2015-06-28 Thread Alex McMurchy
Translating form theory in base to a writer document you would have a form that contains two sub forms. The first sub form would be called Students and source it's data from the Students table and contain the controls FirstName and LastName The second sub form would be called Classes and source

Re: [libreoffice-users] Fresh or Still?

2015-06-24 Thread Alex McMurchy
If in doubt use Still. Alex On 24/06/15 15:59, Tom Davies wrote: Hi :) The "Fresh" has new features and 'better' compatibility with MS Office OOXML formats and more "bug fixes" but all that sometimes means that unexpected features sometimes go a bit wonky. Being "a bit wonky" or out-right not

Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

2015-04-21 Thread Alex McMurchy
I see this problem on Linux LO 4.3.6 On 17/04/15 15:33, Tanstaafl wrote: Hi Alex, Apparently Pedro and Graham don't see this problem on 4.4.x... What version are you on? On 4/17/2015 9:30 AM, Alex McMurchy wrote: Yes same here. The more discontiguous rows selected - right cli

Re: [libreoffice-users] Re: Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

2015-04-19 Thread Alex McMurchy
I don't get the problem on 4.4.2 running Slackware 14.1 I do get the problem on 4.3.2 and 4.3.6 running Slackware 14.1 I get an erratic selection bug on 4.4.2 under writer which has caused be to go back to 4.3.6. Alex On 19/04/15 15:01, Tanstaafl wrote: On 4/19/2015 9:16 AM, Andreas Säger

Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

2015-04-17 Thread Alex McMurchy
Should have mentioned that I originally tested on 4.3.6 which exhibited the problem as described by Tanstaafl. I've subsequently tried it on 4.4.2 and the problem appears fixed. Alex On 17/04/15 14:30, Alex McMurchy wrote: Yes same here. The more discontiguous rows selected - right

Re: [libreoffice-users] Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

2015-04-17 Thread Alex McMurchy
Yes same here. The more discontiguous rows selected - right click is painfully slow to respond selecting subsequent rows is slow to respond Good luck On 17/04/15 11:56, Tanstaafl wrote: Hello, Before I go open a bug (didn't find an existing one), can someone please confirm this for me? Been

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Alex McMurchy
No, I can't believe that Calc is magically converting cells contents to images. Is the cell subject to a formula somewhere else on the sheet? What happens when you try and delete the object that is symbolised by the anchor and green squares along the perimeter? On Tuesday 12 Aug 2014 13:05:48

Re: [libreoffice-users] Question about Calc and hiding rows

2014-08-12 Thread Alex McMurchy
Perhaps you can change the text colour to be the same as the background colour - effectively hiding it. Then protect the sheet/cells as per this in the help https://help.libreoffice.org/Calc/Protecting_Cells_from_Changes On Tuesday 12 Aug 2014 09:16:15 Tom Davies wrote: > Hi :) > +1 > Also ..

Re: [libreoffice-users] SubSubForm in LibreBase

2014-08-07 Thread Alex McMurchy
In the past I've always found this example useful for sub forms https://forum.openoffice.org/en/forum/viewtopic.php?f=100&t=59195 Regards On Friday 01 Aug 2014 13:46:08 Michael Kolowicz wrote: > I working with libre Base 4.2. I have a MainForm. There can a user select > from a list a domain.

Re: [libreoffice-users] MAIL MERGE: Default fields "Topic" and "Subject" are only printed in first document

2014-07-27 Thread Alex McMurchy
for your confirmation. > I've raised a bug to writer component as followed: > > https://www.libreoffice.org/get-help/bug/ > > regards, > Sven > > > On Sat, Jul 26, 2014 at 10:05 AM, Alex McMurchy < > mcmurchy1917-libreoff...@yahoo.co.uk> wrote: > > > S

Re: [libreoffice-users] MAIL MERGE: Default fields "Topic" and "Subject" are only printed in first document

2014-07-26 Thread Alex McMurchy
Sven I can confirm your problem. I see Title/Subject only on the first page irrespective of whether I save the final merged document as a whole or as individual documents. I tested using the Mail Wizard tool. Raise it as a bug and post back here the reference. Alex On Thursday 24 Jul 2014

[libreoffice-users] Re: Automating creation of PDF from Calc

2014-05-12 Thread Alex McMurchy
Well eventually I seem to be getting somewhere. There seems to be a lot of choice. There are some people who use the method of hiding all the sheets except the sheet to be converted into a PDF. Which is the method I used below. Another methed seems to be to use printareas. To me this only seem

[libreoffice-users] Automating creation of PDF from Calc

2014-05-08 Thread Alex McMurchy
Hi all I have a requirement to generate PDF's from specific set sheets contained in one Calc document, the document has 85 individual sheets. I've generated a macro to do this, having first recorded the steps using the macro recorder. Though the steps to record the macro worked perfectly as on

Re: [libreoffice-users] Fwd: ADD NEW MENU BUTTON IN CALC MENUBAR

2014-04-15 Thread Alex McMurchy
I add new menubars/toolbars and button via the menu Tools -> Customise The code behind the button would have already been written as a macro. However, Rajiv explicitly states that he wants to > add a functionality to it without using customizing toolbar If that's the case it would be a questi

Re: [libreoffice-users] Possible LibreOffice Duplex Printing Bug

2014-04-10 Thread Alex McMurchy
Have you compiled Libreoffice yourself? My comments below On Wednesday 09 Apr 2014 14:31:32 CVAlkan wrote: > I'm using the following: > 64 bit Ubuntu 12.04.3 LTS > LibreOffice Version: 4.3.0.0.alpha0+ Build ID: > be4035d00f37c492494fa7860955b6d0868c7f77 > (This is required because of some bu

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-05 Thread Alex McMurchy
Hi Noel So are you trigering these events and running the macros to populate a form from two separate tables? Alex On Sunday 06 Apr 2014 00:13:31 Marion & Noel Lodge wrote: > Hi, > > Sorry I've been slow to respond to all your posts. It has taken me a while > to sort out what I think is happ

Re: [libreoffice-users] Do Macros run serially or in parallel?

2014-04-04 Thread Alex McMurchy
Noel A question inline. Alex On Tuesday 01 Apr 2014 21:57:45 Marion & Noel Lodge wrote: > Hi, > > In opening my database accounting system, I trigger via the Form: When > loading event, a macro, (Sub Init()), containing the database > initialisation routines. > > As the Form loads it displays

Re: [libreoffice-users] conditional formatting broken?

2014-03-26 Thread Alex McMurchy
Tom Perhaps a bit more detail would be useful can you give us the steps that you are following. The steps below would change the font colour of all selected cells that contains the number 0 to the same as the white background, i.e. they become invisible. * Select cells to conditionally

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

2014-03-19 Thread Alex McMurchy
Not sure if I've missed the point here - Create a spreadsheet .ods file with 3 columns each column headed - col1, col2, col3 Add two rows populating respective columns my first row contained 1, 2, 3 and the 2nd row a, b ,c so I had a spreadsheet .ods file that looked like this - col1col2

Re: [libreoffice-users] Similar Problem?

2014-03-04 Thread Alex McMurchy
enginefrom hsql to something else. Vince Radice On 02/03/2014 08:09 AM, Alex McMurchy wrote: Vince Have you solved this problem? If not - have you tried starting a completelynew configuration directory?

Re: [libreoffice-users] LibréOffice Base Forms, PostgreSQL (JDBC) and Table Joins

2014-02-23 Thread Alex McMurchy
Jim Is it that you want a single form, comprised of sub forms, whereby you can filter assets according to their status i.e. "deployed" or "in stock"; from the results given select a specific asset which presents the result, of that one asset, in a sub form from which the asset can be amended?

Re: [libreoffice-users] HOW CAN I CONVERT A NUMBER IN LibreOffice CALC TO TEXT IN LibreOffice CALC?

2014-02-21 Thread Alex McMurchy
Try this link. Specifically the function getAmountInWord in the described macro. Don't try the extension. Alex On Friday 21 Feb 2014 15:29:18 Tom Davies wrote: > Hi :) > It's an unusual problem that looks a lot like a fairly frequently > asked question. Your question has an extra twist which

Re: [libreoffice-users] Mail Merge Wizard fails in 4.2.0

2014-02-18 Thread Alex McMurchy
he main reason it's good to ask this mailing list is if you are a new > user, perhaps more familiar with other office suites, and have not yet > read up much of the documentation nor gained years of experience using > LO/OOo/AOO. > > Regards from > Tom :) > > >

[libreoffice-users] Mail Merge Wizard fails in 4.2.0

2014-02-15 Thread Alex McMurchy
Has anyone else had a problem with the MailMerge Wizard in 4.2.0? In release 4.1.4 and all previous releases it produced the merged data. In release 4.2.0 it gives every indication that it is doing the business by stepping, the correct number of times, through the records in the selected addres

Re: [libreoffice-users] Similar Problem?

2014-02-03 Thread Alex McMurchy
o, how do I fix the problem of empty files?Thanks,Vince Radice On 01/17/2014 03:28 AM, Alex McMurchy wrote: Vince In respect of the empty files - * Which version of LibreOffice are you using?

Re: [libreoffice-users] Base Table Relation

2014-01-30 Thread Alex McMurchy
You can creta a form based on queries as well as a table. https://help.libreoffice.org/Common/Queries Alex On Wednesday 29 Jan 2014 21:36:56 Mark LaPierre wrote: > Hey Y'all, > > I've been struggling with this for weeks. I've got the Base Handbook > for Version 4 that goes along really well

Re: [libreoffice-users] Similar Problem?

2014-01-17 Thread Alex McMurchy
ion > >> guidelines > >> that I had found but was unable to get it to work. I created the Mysql > >> database and was able to create and load the tables (I think) but I could > >> never get Base to recognize and use it. All of my queries and reports are > >>

Re: [libreoffice-users] Similar Problem?

2014-01-17 Thread Alex McMurchy
. I created the Mysql > >> database and was able to create and load the tables (I think) but I could > >> never get Base to recognize and use it. All of my queries and reports are > >> in Base. I may have to try again if I can find the time. This time I will > &

Re: [libreoffice-users] Similar Problem?

2014-01-15 Thread Alex McMurchy
hing at all for base documents. > > Alex > > > > On Wednesday 15 Jan 2014 14:35:33 Alex McMurchy wrote: > > I used to have that problem. It seems to have stopped around about 16th > > July 2013. Not sure why! > > > > Either - > > > > I upgraded

Re: [libreoffice-users] Similar Problem?

2014-01-15 Thread Alex McMurchy
I used to have that problem. It seems to have stopped around about 16th July 2013. Not sure why! Either - I upgraded LibreOffice which stopped the feature or I did something else which I can't remember! I'm currently on 4.1.4.2. Alex On Wednesday 15 Jan 2014 07:38:25 Tom Davies wrote: > H