[libreoffice-users] Re: Native MySQL-connection

2011-06-06 Thread Alexander Thurgood
Le 05/06/11 21:25, Heinrich Stoellinger a écrit : Hi Heinrich, I use Debian-Squeeze at the moment. Having spent too much time already doing things where I don't understand all the possible ramifications - I hesitate to delete /tmp. Is it o.k. for sure to do so or might I hurt something in

[libreoffice-users] Re: LibreOffice 3.4 Base Form Background Colour

2011-06-06 Thread Alexander Thurgood
Le 06/06/11 06:23, dreamquartz a écrit : Hi, Cannot select background colour when starting form in LO 3.4 Base. Any thoughts? https://bugs.freedesktop.org/show_bug.cgi?id=37626 https://bugs.freedesktop.org/show_bug.cgi?id=36107 https://bugs.freedesktop.org/show_bug.cgi?id=37619 Alex

[libreoffice-users] Re: Is this list unmoderated?

2011-06-06 Thread plino
Nabble just LOOKS like a forum. Functionally, it's not. You have to subscribe to each section because each is a separate mailing list. If Mono works in the same way, then it's not an alternative. Please TDF consider setting up an OFFICIAL forum! -- View this message in context:

[libreoffice-users] Re: Multuple rules/conditions to range of cells

2011-06-06 Thread Andreas Säger
Am 05.06.2011 18:47, PLO wrote: Hello LO Users, I've been trying - without success - to apply five separate conditional formatting rule to a column based on their value. Each of the 365 cells in the column contain a simple formula. E.g =SUM((N151+L152)-(P152+R152)) I need the result

Re: [libreoffice-users] Re: Is this list unmoderated?

2011-06-06 Thread Tom Davies
+1 - Original Message From: plino pedl...@gmail.com To: users@libreoffice.org Sent: Mon, 6 June, 2011 9:53:30 Subject: [libreoffice-users] Re: Is this list unmoderated? Nabble just LOOKS like a forum. Functionally, it's not. You have to subscribe to each section because each

[libreoffice-users] Re: Multuple rules/conditions to range of cells

2011-06-06 Thread Andreas Säger
Am 05.06.2011 18:47, PLO wrote: Hello LO Users, I've been trying - without success - to apply five separate conditional formatting rule to a column based on their value. Each of the 365 cells in the column contain a simple formula. E.g =SUM((N151+L152)-(P152+R152)) Second method is

Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells

2011-06-06 Thread PLO
Hello Andreas, On Mon, 06 Jun 2011 11:00:26 +0200 (your time) you said: Second method is much easier but resticted to the formula cells you mentioned. 1. Create your set of cell styles as in the above solution. 2. =SUM((N151+L152)-(P152+R152))+STYLE(VLOOKUP(CURRENT();$X$1:$Y$6;2) Function

[libreoffice-users] [Bug] LibreOffice 3.4.0 - Explorer crashes

2011-06-06 Thread Darkguy
Found this when trying to repair a user netbook at our university's helpdesk: -) Samsung NF 310 (Atom N550, 2 GB RAM, 250 GB HDD, Windows 7 Starter/32 Bit) Problem: Windows loads, user logs in, as soon as the Desktop loads, explorer.exe crashes, then auto-restarts, then crashes again, things go

Re: [libreoffice-users] Multuple rules/conditions to range of cells

2011-06-06 Thread Tom Davies
Hi :) The InsertImages etc refers to the menus at the top of the Writer window. Note that the menus at the top are File EditViewInsertHelp So click on the Insert menu. The menu drops down and contains similar items grouped together rather than being alphabetical. The

Re: [libreoffice-users] [Bug] LibreOffice 3.4.0 - Explorer crashes

2011-06-06 Thread Tom Davies
Hi :) That is worth posting a bug-report about http://wiki.documentfoundation.org/BugReport Obviously it's better practice to minimise the number of things that automatically start at boot-up but users can be a bit strange sometimes and we should be able to cater to that. FireFox or almost

[libreoffice-users] Re: [Bug] LibreOffice 3.4.0 - Explorer crashes

2011-06-06 Thread Darkguy
Same behaviour with 3.3.2. Basically a virgin Windows 7 Starter, not even any Samsung tools/drivers installed. Only other software is IE9, Chrome (current version), Intel GMA driver, JAVA 6u25, MS Security Essentials, Silverlight, MS VC++ 2008 redistributable 9.0.30729.17 and 3.30729.4148, .NET

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

2011-06-06 Thread Jack
plino wrote: But as you said, I really don't want to browse 300.000 lines to spot errors ;) Hi plino, for your specific case I might have a possible workaround. The following formula (place it in any cell) would give you the row number for the first non-numeric value in the range A1:A3.

[libreoffice-users] Re: Incredibly annoying highlight problem!

2011-06-06 Thread Jack
I believe this is related to: https://bugs.freedesktop.org/show_bug.cgi?id=37955 Regards Jack -- View this message in context: http://nabble.documentfoundation.org/Incredibly-annoying-highlight-problem-tp3022377p3029830.html Sent from the Users mailing list archive at Nabble.com. --

[libreoffice-users] Re: Consistent 3.4.0 crash in Calc when Linking to External Data

2011-06-06 Thread Andy M
Full clean install did not fix the problem. The exception apparently occurs in MSVCR90.DLL, the Visual C++ 2008 runtime library. The version of that DLL is different between my 32-bit WinXP system and the 64-bit Win7 AMD system, which might explain why it's not failing on the Win7. It looks

Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells

2011-06-06 Thread Michael D. Setzer II
On 6 Jun 2011 at 10:55, Andreas Säger wrote: To: users@libreoffice.org From: Andreas Säger ville...@t-online.de Subject: [libreoffice-users] Re: Multuple rules/conditions to range of cells Date sent: Mon, 06 Jun 2011 10:55:43 +0200 Send reply to: users@libreoffice.org Am 05.06.2011 18:47, PLO

Re: [libreoffice-users] Multuple rules/conditions to range of cells

2011-06-06 Thread Sigrid Carrera
Hi Lynn, On Sun, 5 Jun 2011 22:32:20 -0700 (PDT) Lynn Wilde life48dan...@att.net wrote: I do have a question. I copied a book that I wrote with MS Word on to LibreOffice, but none of the pictures transferred, only boxes where the pictures would be. The computer on which I wrote the

[libreoffice-users] Problem in 3.4.0 - external links in CALC

2011-06-06 Thread OBUTEX/Hladůvka
Hi, on WIN XP i had installed LO 3.4.0. and there occured this problem: I have several files - Comp1report.ods with sheets Data,Param,report - Comp2report.ods with sheets Data,Param,report - Comp3report.ods with sheets Data,Param,report (each file has a range A1:E30 named as Report in the

Re: [libreoffice-users] Re: Native MySQL-connection

2011-06-06 Thread Roland Hughes
There are flags that you need to set. Do a search on-line. In OpenSuSE you set them with YAST, I forget where you set them with Ubuntu. /tmp is only cleaned at system boot, when it should be empty. Ubuntu has a lot of bugs with respect to cleaning of /tmp at system boot. It basically doesn't

Re: [libreoffice-users] Multuple rules/conditions to range of cells

2011-06-06 Thread Tom Davies
Hi :) You should be able to just double-click on documents that were written in Word and they should just open in LibreOffice now. If not then right-click on the Word file and choose Open with ... and then find LibreOffice or Writer in the list. It is smart to create a back-up copy before

[libreoffice-users] Request for Technical assistance.

2011-06-06 Thread Ruth C. Reidbord
My son-in-law installed Libre Office for me last month when I purchased a new computer. It worked fine until last week. Last week I received a document as an attachment on my Email which contained a survey to which I wanted to reply. I couldn't type in the answers so I cut and pasted it to

Re: [libreoffice-users] Request for Technical assistance.

2011-06-06 Thread Tom Davies
Hi :) Answer are often given at the bottom of threads rather than at the top so it's worth checking there if there appears to be no answer in a reply. From what i have seen here so far i think that downloading and saving the attachment before trying to open it might work better. Also when

Re: [libreoffice-users] Request for Technical assistance.

2011-06-06 Thread PLO
Hello Ruth, On Mon, 06 Jun 2011 11:58:53 -0400 (your time) you said: so I can't type documents and I can't access my files. When I hit Libre Office on my Desktop, nothing happens. I don't know what to do. Please help me. If you using Windows, then you could open Control Panel, Select the Add

[libreoffice-users] Re: Consistent 3.4.0 crash in Calc when Linking to External Data

2011-06-06 Thread Andy M
OK, I see this bug has already been reported: https://bugs.freedesktop.org/show_bug.cgi?id=37673 Hope they fix it soon! -- View this message in context: http://nabble.documentfoundation.org/Consistent-3-4-0-crash-in-Calc-when-Linking-to-External-Data-tp3026245p3031776.html Sent from the Users

[libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Johnny Rosenberg
CDbl returns an integer when the argument is a text string. LibreOffice 3.4.0 OOO340m1 (Build:12) OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1 Ubuntu 10.10 REM * BASIC * Option Explicit Sub Main Print CDbl(123.45) ' This

Re: [libreoffice-users] Re: Consistent 3.4.0 crash in Calc when Linking to External Data

2011-06-06 Thread Cor Nouws
Andy M wrote (06-06-11 22:25) OK, I see this bug has already been reported: https://bugs.freedesktop.org/show_bug.cgi?id=37673 Hope they fix it soon! Yip! And thanks for reporting back that you found the issue, Andy. Many hands make heavy work light ;-) -- - Cor -

[libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Regina Henschel
Hi Johnny, Johnny Rosenberg schrieb: CDbl returns an integer when the argument is a text string. LibreOffice 3.4.0 OOO340m1 (Build:12) OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1 Ubuntu 10.10 REM * BASIC * Option Explicit

Re: [libreoffice-users] Re: Multuple rules/conditions to range of cells

2011-06-06 Thread Michael D. Setzer II
On 6 Jun 2011 at 21:59, Andreas Säger wrote: To: users@libreoffice.org From: Andreas Säger ville...@t-online.de Subject:[libreoffice-users] Re: Multuple rules/conditions to range of cells Date sent: Mon, 06 Jun 2011 21:59:48

Re: [libreoffice-users] I have to ask (four qustions)

2011-06-06 Thread Nuno J. Silva
Johnny Rosenberg gurus.knu...@gmail.com writes: 2011/6/5 Nuzhna Pomoshch nuzhna_pomos...@yahoo.com: --- On Sat, 5/28/11, Johnny Rosenberg gurus.knu...@gmail.com wrote: 3. How do I get hidden (dot directories) to appear in the open and save dialog boxes (they appear in all of the window

[libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Clio
06.06.2011 16:26, Johnny Rosenberg пишет: CDbl returns an integer when the argument is a text string. LibreOffice 3.4.0 OOO340m1 (Build:12) OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1 Ubuntu 10.10 REM * BASIC * Option Explicit

[libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Clio
06.06.2011 16:54, Regina Henschel пишет: Is this a bug? No, see help text. If the separator is dot, then no problems, but if the separator is comma, then this is the bug, see http://openoffice.org/bugzilla/show_bug.cgi?id=70236 -- Unsubscribe instructions: E-mail to

Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Johnny Rosenberg
2011/6/6 Regina Henschel rb.hensc...@t-online.de: Hi Johnny, Johnny Rosenberg schrieb: CDbl returns an integer when the argument is a text string. LibreOffice 3.4.0 OOO340m1 (Build:12) OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 3.2.1.4, Ubuntu package 1:3.2.1-7ubuntu1.1

Re: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Johnny Rosenberg
2011/6/6 Clio mene...@bk.ru: 06.06.2011 16:54, Regina Henschel пишет: Is this a bug? No, see help text. If the separator is dot, then no problems, but if the separator is comma, then this is the bug, see http://openoffice.org/bugzilla/show_bug.cgi?id=70236 Okay, I see. Thanks, Clio!

[libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string argument

2011-06-06 Thread Tom Davies
- Original Message From: Johnny Rosenberg gurus.knu...@gmail.com To: users@libreoffice.org Sent: Mon, 6 June, 2011 22:24:22 Subject: Re: [libreoffice-users] Re: [libreoffice-users] Re: [libreoffice-users] LibreOffice/OpenOffice.org BASIC – CDbl doesn't work properly with string

[libreoffice-users] Delete key doesn't work in the Basic Macro editor!

2011-06-06 Thread Johnny Rosenberg
LibreOffice 3.4 (the one at the Libre Office site, the most recent one released 2011-06-03) Ubuntu 10.10 When writing BASIC macros I can't delete with the Delete key, so I need to move the cursor and delete using the Backspace key instead. Works perfectly with OpenOffice.org 3.2 (Ubuntu version)

Re: [libreoffice-users] Re: Re: LibreOffice 3.4.0

2011-06-06 Thread Nuno J. Silva
tronkel saunders.j...@gmail.com writes: On 06/05/2011 11:06 AM, tronkel wrote: 3.4.0 shows a correctly installed CUPS printer but refuses to actually print the job. [...] The 2 systems on which I have tried LO 3.4.0 are Slackware 13.37 and Puppy Linux Wary 5.1.2. The printer itself

Re: [libreoffice-users] Delete key doesn't work in the Basic Macro editor!

2011-06-06 Thread Nuno J. Silva
Johnny Rosenberg gurus.knu...@gmail.com writes: LibreOffice 3.4 (the one at the Libre Office site, the most recent one released 2011-06-03) Ubuntu 10.10 When writing BASIC macros I can't delete with the Delete key, so I need to move the cursor and delete using the Backspace key instead.

Re: [libreoffice-users] Delete key doesn't work in the Basic Macro editor!

2011-06-06 Thread Johnny Rosenberg
2011/6/6 Nuno J. Silva nunojsi...@ist.utl.pt: Johnny Rosenberg gurus.knu...@gmail.com writes: LibreOffice 3.4 (the one at the Libre Office site, the most recent one released 2011-06-03) Ubuntu 10.10 When writing BASIC macros I can't delete with the Delete key, so I need to move the cursor

[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

2011-06-06 Thread plino
Hi Jack I couldn't make it work. In fact I just found out that array functions don't work in Lib (3.3 or 3.4) nor in OOo (3.4 beta) I don't know if it ever worked (I use it every now and then, so I couldn't say if I used it before in OOo/LO) but if it did, someone broke it :) Another bug to fix

[libreoffice-users] OOo extension services back up again - with some updated dictionaries

2011-06-06 Thread Kracked Press Productions
http://extensions.services.openoffice.org is back running again - finally Plus they have the French dictionary updates, with others as well. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting

[libreoffice-users] infinite pagination loop on open of docx

2011-06-06 Thread jharan
Hi, I attempt to open a 53 page .docx document (from MS Office 2010) with LibreOffice 3.3.1 (Suse Linux 11.2). The document opens (shows Page 1/53 in the lower left corner) and is pretty much readable but then if I scroll down a couple of pages, its interface will freeze and in the lower left

Re: [libreoffice-users] infinite pagination loop on open of docx

2011-06-06 Thread planas
Jeff On Mon, 2011-06-06 at 23:44 +, jha...@comcast.net wrote: Hi, I attempt to open a 53 page .docx document (from MS Office 2010) with LibreOffice 3.3.1 (Suse Linux 11.2). The document opens (shows Page 1/53 in the lower left corner) and is pretty much readable but then if I scroll

Re: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

2011-06-06 Thread nvrk
On Mon, Jun 6, 2011 at 3:40 PM, plino pedl...@gmail.com wrote: Hi Jack I couldn't make it work. In fact I just found out that array functions don't work in Lib (3.3 or 3.4) nor in OOo (3.4 beta) I don't know if it ever worked (I use it every now and then, so I couldn't say if I used it