Re: [users] Re: The user interface language cannot be determined...now what? SOLVED!

2008-09-19 Thread Verner Kjærsgaard
NoOp skrev: On 09/18/2008 12:57 PM, Verner Kjærsgaard wrote: NoOp skrev: On 09/18/2008 07:13 AM, Verner Kjærsgaard wrote: Dear list, - On SuSE11, OO version 2.4 (danish) will not launch anymore. - it gives me a dialogbox that goes: The user interface language cannot be determined - you

[users] Re: Crossreferencing to a listitem number

2008-09-19 Thread Larry Evans
On 01/05/08 10:53, Michele wrote: On Jan 3, 2008 7:56 PM, Mats Broberg [EMAIL PROTECTED] wrote: Dan, Thanks - but I need it to print at the crossref position (physically on paper). The reason I need this behavior is that I am adding endnotes to the body and footnote area of a historical text

[users] missing listitem_num_ref.html file (was Re: Crossreferencing to a listitem number

2008-09-19 Thread Larry Evans
On 09/19/08 08:27, Larry Evans wrote: [snip] Docbook has a simple way of doing this. Attached are the input .xml file and the (pretty printed) output .html file. Also attached is the .xsl file doing the transformation. For some reason my mailer dropped the .html file. I tried again to attach

[users] once again with cutpaste (was Re: missing listitem_num_ref.html file (was Re: Crossreferencing to a listitem number

2008-09-19 Thread Larry Evans
On 09/19/08 08:46, Larry Evans wrote: On 09/19/08 08:27, Larry Evans wrote: [snip] Docbook has a simple way of doing this. Attached are the input .xml file and the (pretty printed) output .html file. Also attached is the .xsl file doing the transformation. For some reason my mailer dropped

[users] x-axis formatted to show months

2008-09-19 Thread Graham Smith
I'm sure this must be an faq, but If want to plot dates along the x-axis, but have the axis display tick marks based on months, how do I do this. I thought it be a formatting option for the x-axis, but I can't find it. Can someone point me in the right direction. Many thanks, Graham

[users] [Solved] Re: The user interface language cannot be determined...now what? SOLVED!

2008-09-19 Thread NoOp
On 09/18/2008 11:11 PM, Verner Kjærsgaard wrote: I found the reg file you mentioned by using find and so forth. Changed its permissions, - and voila! Thanks a million! Cool. Glad you got it fixed :-) - To

Re: [users] Microsoft Access compatibility

2008-09-19 Thread Mark Knecht
Barbara, My associate in Australia replied overnight that there is a password. However I cannot figure out in Base where I enter the password. Where do I do that? Thanks, Mark On Thu, Sep 18, 2008 at 6:41 PM, Barbara Duprey [EMAIL PROTECTED] wrote: OK, send it along -- I'm on 2.4.1 and

[users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread Joe Smith
Joe Smith wrote: James Elliott - WA Rural Computers wrote: When I saved a Calc spreadsheet in Excel format to send to my Accountant, the SUMPRODUCT formulas did not work because a Calc formula like this: =SUMPRODUCT(A1:A3000; B1:B3000) was converted to : =SUMPRODUCT(A1:A3000, B1:B3000) ie

[sw-users] http://www.openoffice.org/issues/show_bug.cgi?id=74236 - call for attention

2008-09-19 Thread Branislav Klocok
Hello everybody, I am the lead of Slovakian NL project and one of our users is for some time trying to find a solution for the abovementioned issue, but already for some time there is no reaction. Can someone take a look please. Best regards, PS: sorry for crossposting -- Branislav Klocok

[users] Re: UK English version

2008-09-19 Thread NoOp
On 09/17/2008 11:32 AM, Harold Fuchs wrote: On 17/09/2008 12:41, TomW wrote: [snip] Harold: If you click on the 'Parent Directory' a couple of times, it will take you to where you can select the 'Extended' directory. TomW a) Why would I do that? b) Even if I do I don't see anything that

Re: [users] x-axis formatted to show months

2008-09-19 Thread Brian Barker
At 15:47 19/09/2008 +0100, Graham Smith wrote: I'm sure this must be an faq, but If want to plot dates along the x-axis, but have the axis display tick marks based on months, how do I do this. I thought it be a formatting option for the x-axis, but I can't find it. How is your data arranged?

Re: [users] x-axis formatted to show months

2008-09-19 Thread Graham Smith
Brian, I'm sure this must be an faq, but If want to plot dates along the x-axis, but have the axis display tick marks based on months, how do I do this. I thought it be a formatting option for the x-axis, but I can't find it. How is your data arranged? If your data is arranged with a single

Re: [users] x-axis formatted to show months

2008-09-19 Thread Graham Smith
I wonder if release 3 can do this? I have just had a look and indeed release 3 does have an option to format the x-axis as dates, and it sort of does it, but the spacing of the labels seem to sit at the end of the month rather than the beginning of the month. So events in January look as if

Re: [users] Microsoft Access compatibility

2008-09-19 Thread Barbara Duprey
I've never gotten into that, and the built-in Help doesn't seem to help. It seems to imply that a dialog will open automatically if a password is required, which is what I'd expect, but that isn't happening for you. Have you tried opening the mdb file both from inside Base, and by

Re: [users] Microsoft Access compatibility

2008-09-19 Thread Barbara Duprey
Oops -- sorry, I know you're not opening the mdb file but trying to connect to it. It seems as if when Base tries the connection, it's recognizing the file is protected but is supplying a default password instead of asking for one. Barbara Duprey wrote: I've never gotten into that, and the

Re: [users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread James Elliott - WA Rural Computers
Hi Joe I tried replacing the explicit multipliers with commas in this formula: =SUMPRODUCT((chqDEBIT)*(chqCODE=A13)*(chqDATE=$D$4)*(chqDATE=$D$5)) ie. I made it read: =SUMPRODUCT(chqDEBIT,chqCODE=A13,chqDATE=$D$4,chqDATE=$D$5) and the formula no longer worked! The sumproduct total I had in

Re: [users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread James Elliott - WA Rural Computers
Hi again Joe In the smiple example I gave in my original post, i deliberatly kept it simple to get my point accross. however, as you can see in this real life formula: =SUMPRODUCT((chqDEBIT)*(chqCODE=A13)*(chqDATE=$D$4)*(chqDATE=$D$5)) my formula does, indeed, contain boolean tests so you

[users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread Joe Smith
James Elliott - WA Rural Computers wrote: ... So, in Calc (forget Excel) we can use either of these formats, can we?: =SUMPRODUCT(A1:A3000; D1:D3000=TEST) or =SUMPRODUCT((A1:A3000)*(D1:D3000=TEST)) Am I correct? Yes, I believe that is correct. Logical tests in Calc always produce numeric

[users] Re: INTERESTING SUMPRODUCT OBSERVATION.?

2008-09-19 Thread Joe Smith
James Elliott - WA Rural Computers wrote: ... ie. I made it read: =SUMPRODUCT(chqDEBIT,chqCODE=A13,chqDATE=$D$4,chqDATE=$D$5) and the formula no longer worked! The sumproduct total I had in that cell just disappeared - no error message, just no result. If you're working in Calc then you

[users] Re: Microsoft Access compatibility

2008-09-19 Thread NoOp
On 09/19/2008 08:02 AM, Mark Knecht wrote: Barbara, My associate in Australia replied overnight that there is a password. However I cannot figure out in Base where I enter the password. Where do I do that? Thanks, Mark Don't know, but I just opened up MS Access '97 and the help file