re: [libreoffice-users] Problems using VLOOKUP in Libreoffice Calc

2011-08-29 Thread Gérard FARGEOT
Hello, Message du 29/08/11 01:18 De : minnesotauser A : users@global.libreoffice.org Copie à : Objet : [libreoffice-users] Problems using VLOOKUP in Libreoffice Calc I have two columns set up like so: a | 1 b | 2 c | 3 I want to be able to use a number from column B and have the

[libreoffice-users] 2Q -- WollMux for LibreOffice? -- Archives area?

2011-08-29 Thread Russell Wilson
The WollMux extension is listed on the extensions site but clicking on it leads to a page missing error. When downloading and trying to install it from a third party, it says it's unable to be installed due to OOo not being installed. Will there be a version available for LO? Is there an

[libreoffice-users] Re: Spreadsheet 3.4.2 Bug

2011-08-29 Thread Alexander Thurgood
Le 27/08/11 22:15, Andreas Säger a écrit : Hi Andreas, This is the intended behaviour as it used to be specified for OOo, and Nicolás document behaves perfectly normal : Default print range is a sheet's used range unless you define anything anywhere in the document. Yes, indeed, as I have

[libreoffice-users] New to Group, and so checking on Browser Plug-in

2011-08-29 Thread Russell Wilson
Trying to use LO 3.4.2 on Win 7 x64 and can't get browser plug-in to work -- been trying to read some of the LO manuals on line, so program/browser seems to fail half-way --  screen gets half-greyed out (with white in other half of window where od should be viewable but nothing to read!) --

Re: [libreoffice-users] Linked Cell says True instead of Showing the value

2011-08-29 Thread nvrk
Do you think that this could be a cell format problem? nvsoar On Aug 28, 2011 5:34 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/8/28 Tom Davies tomdavie...@yahoo.co.uk: Hi :) Even just copypasting the equation into a reply to this thread might help ;) Regards from Tom :) Might

[libreoffice-users] Re: Calc row filter extraction

2011-08-29 Thread Olivier Bietzer
Yes, I do agree But when there is only one table, Calc will do the job, no ? No need to use a hammer to slam a fly... Regards from Olivier Le 28/08/2011 21:12, Andreas Säger a écrit : What you do in that spreadsheet would be a 100% database task. The data pilot is Calc's most database-ish

Re: [libreoffice-users] Re: Spreadsheet 3.4.2 Bug

2011-08-29 Thread Cor Nouws
Alexander Thurgood wrote (29-08-11 09:10) There is a bug is in the print preview. It should always display anything printable. That is either the used ranges of all sheets or the collection of explicitly defined ranges. Currently it shows the used/defined range of the current sheet only. I

[libreoffice-users] Problem with data conversion

2011-08-29 Thread James Wilde
Can't think of a better subject line. This is about the Ubuntu repository version of LibO running under Ubuntu 11.04 linux. The repository version is described as follows: LibreOffice 3.3.3 OOO 330m 19 (Build:301) LibreOffice 3.3.3.1 Ubuntu package 1.3.3.3ubuntu2 I have been testing Gnucash

[libreoffice-users] Re: Re: strikethrough feature

2011-08-29 Thread Twayne
Hi Johnny, Thanks for the comeback; it's handy to get slapped with a reminder now then about English not being a poster's first language. It wasn't obvous to me at all so you're doing pretty darned good. I am of the opinion your problem is a small one but there are still some things that

[libreoffice-users] Re: Re: strikethrough feature

2011-08-29 Thread Twayne
Hi Johnny, Thanks for the comeback; it's handy to get slapped with a reminder now then about English not being a poster's first language. It wasn't obvous to me at all so you're doing pretty darned good. I am of the opinion your problem is a small one but there are still some things that

[libreoffice-users] Re: Suggestions to PTB

2011-08-29 Thread Twayne
In news:j3ap2n$4u8$1...@dough.gmane.org, Alexander Thurgood alex.thurg...@gmail.com typed: Le 26/08/11 19:14, Twayne a icrit : Hi Twayne, But MS fixes their bugs and will continue to do so until 2014 in my case. I am trying to get them to think about the problem that lost them a lof of

[libreoffice-users] Re: LO Impress 3.3.3 crashes Windows and Ubuntu

2011-08-29 Thread stan
UPDATE: The same problem now re-occurred with LO writer. Unfortunately, although running through strace, no strace.log to be found on the system. -- View this message in context: http://nabble.documentfoundation.org/LO-Impress-3-3-3-crashes-Windows-and-Ubuntu-tp3258408p3291282.html Sent from

Re: [libreoffice-users] 2Q -- WollMux for LibreOffice? -- Archives area?

2011-08-29 Thread Tom Davies
Hi :) The Nabble 'forum' is one way of viewing threads from the mailing list http://nabble.documentfoundation.org/Users-f1639498.html and there is a search feature at the top-right. LibreOffice is just beta-testing it's own Extensions Web-page and there will be an announcement about it soon to

[libreoffice-users] Re: Linked Cell says True instead of Showing the value

2011-08-29 Thread Andreas Säger
Am 29.08.2011 09:13, nvrk wrote: Do you think that this could be a cell format problem? nvsoar Could be. Nobody can tell without any data nor formulas from the original poster. Unlike Excel, the boolean data type is just a subtype of the decimal type. The number format BOOLEAN displays any

[libreoffice-users] Libre Help file in Windows 7

2011-08-29 Thread Tinkerer
A friend has installed Libre 3.4.2 on his Windows 7 computer. He then installed the Libre Help file and Windows put it in Documents. It does not work. Where should it be? BTW. I am a Mac user. Tink. -- View this message in context:

[libreoffice-users] Dictionaries installed but not available

2011-08-29 Thread Rogier F. van Vlissingen
I've installed a dictionary (Dutch) and it appears to be available in tools/language settings/writing aids, but it's not available when I try to set the language of a document? What gives? -- Using Opera's revolutionary email client: http://www.opera.com/mail/ -- For unsubscribe

[libreoffice-users] import data from FileMaker Pro?

2011-08-29 Thread Paul Hochbaum
Hello, do you have any idea, how to import data from FileMaker Pro databases in order to convert them into a libre database? Thx, Paul H-2045 Törökbálint Tükörhegy utca 6. E-Mail: h...@baum.hu Tel.: +36 20 956 09 96 Fax: +36 23 890 770 -- For unsubscribe instructions e-mail to:

[libreoffice-users] strikethrough in draw

2011-08-29 Thread Andre
Hi all, it seems like a simple question, but maybe not. In Draw, I want to strikethrough the text of a connector shape. I can choose the option from the context/character menu of the shape but nothing happens on the screen. Same with underlining. Has anyone experienced this and knows a solution?

Re: [libreoffice-users] New to Group, and so checking on Browser Plug-in

2011-08-29 Thread Tom Davies
Hi :) If you open the manuals/guides by doing a right-click and then open in a new tab then you can give it plenty of time to open. The full books take ages to download but the individual chapters should only take a couple of minutes. Where the web-pages normally appear, ie inside the tab,

Re: [libreoffice-users] Dictionaries installed but not available

2011-08-29 Thread Guy Voets
2011/8/29 Rogier F. van Vlissingen vlisc...@gmail.com: I've installed a dictionary (Dutch) and it appears to be available in tools/language settings/writing aids, but it's not available when I try to set the language of a document? What gives? Hello Rogier, Did you define the language of the

[libreoffice-users] Re: import data from FileMaker Pro?

2011-08-29 Thread Andreas Säger
http://help.filemaker.com/app/answers/detail/a_id/7700/~/installing-odbc-and-jdbc-for-filemaker-11 This is not a question of file formats. You can connect FileMaker to Base like you can connect it to MS Query or MS Access. -- View this message in context:

[libreoffice-users] CURRENT_DATE or TODAY default date in Base

2011-08-29 Thread John Mullen
Hi Guys, I'm trying to set a default date ( CURRENT_DATE or TODAY ) ie, Todays date into a date field in a Base Form with no luck. Also tried to enter it into the table as a default date - no luck. Please advise if this is a known bug and if there is a workaround. Best regards John --

Re: [libreoffice-users] New to Group, and so checking on Browser Plug-in

2011-08-29 Thread webmaster for Kracked Press Productions
My question is: Why are you reading them online instead of downloading them? Even though I have 24/7 broadband access, I still prefer download my documents then read the offline. full books takes ages - not for broadband. Most seem to be under 20MB. The graying is something I hate, and

[libreoffice-users] Re: CURRENT_DATE or TODAY default date in Base

2011-08-29 Thread Andreas Säger
The Base GUI is too stupid to do that trick. It all depends on the database you are actually using. For the embedded HSQLDB type of database that is: menu:ToolsSQL... ALTER TABLE My Table ALTER COLUMN My Date DATE DEFAULT CURRENT_DATE NOT NULL You may leave out NOT NULL or you may unckeck

Re: [libreoffice-users] 2Q -- WollMux for LibreOffice? -- Archives area?

2011-08-29 Thread webmaster for Kracked Press Productions
I Google-ed that extension and there was a lot of talk of issues with that extension and OOo. I then went to the OOo extension site. It seems that searching for WollMux list nothing now. On 08/29/2011 06:24 AM, Tom Davies wrote: Hi :) The Nabble 'forum' is one way of viewing threads from

[libreoffice-users] Re: import data from FileMaker Pro?

2011-08-29 Thread Alexander Thurgood
Le 29/08/11 13:40, Paul Hochbaum a écrit : Hi Paul, do you have any idea, how to import data from FileMaker Pro databases in order to convert them into a libre database? For the data, I have used CSV or SYLK in the past. For the structure, export to *.BAS or *.MER (if those options are

[libreoffice-users] How to disable the mail-merge-wizard in LibreOffice?

2011-08-29 Thread Claus Berghammer (Bugzilla)
Hello LibreOffice Users, I'm using a template with database-fields in it on a regularly basis, but don't want to print a mass-mailing. Currently I have to click NO every time again, when I am printing this document. In OOo it was possible to disable that Dialogue by adding some lines to

Re: [libreoffice-users] Libre Help file in Windows 7

2011-08-29 Thread planas
Tink On Mon, 2011-08-29 at 04:15 -0700, Tinkerer wrote: A friend has installed Libre 3.4.2 on his Windows 7 computer. He then installed the Libre Help file and Windows put it in Documents. It does not work. Where should it be? There is a default location for the help file that is used. I

[libreoffice-users] Re: Libre Help file in Windows 7

2011-08-29 Thread Dave Sergeant
On my Windows XP PC help is at c:\Program Files\Libre Office3.4\Basis\Help\en-GB There is a large number of files and folders there. Dave On 29 Aug 2011 at 12:46, planas wrote: A friend has installed Libre 3.4.2 on his Windows 7 computer. He then installed the Libre Help file and Windows

[libreoffice-users] Re: 2Q -- WollMux for LibreOffice? -- Archives area?

2011-08-29 Thread NoOp
On 08/28/2011 10:28 PM, Russell Wilson wrote: The WollMux extension is listed on the extensions site but clicking on it leads to a page missing error. When downloading and trying to install it from a third party, it says it's unable to be installed due to OOo not being installed. Will

[libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread James
I'm having a bit of trouble with Page Styles and Fields in Writer. It's a pretty simple test file. The current page Field works the way I want but the page count Field is not what I want. http://lockie.ca/test/pageTest.odt.bz2 -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread Cor Nouws
Hi James, James wrote (29-08-11 20:16) I'm having a bit of trouble with Page Styles and Fields in Writer. It's a pretty simple test file. The current page Field works the way I want but the page count Field is not what I want. http://lockie.ca/test/pageTest.odt.bz2 On the paragraph 'normal

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread webmaster for Kracked Press Productions
On 08/29/2011 02:16 PM, James wrote: I'm having a bit of trouble with Page Styles and Fields in Writer. It's a pretty simple test file. The current page Field works the way I want but the page count Field is not what I want. http://lockie.ca/test/pageTest.odt.bz2 looked at your file. Try

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread James
On 08/29/11 15:39, webmaster for Kracked Press Productions wrote: On 08/29/2011 02:16 PM, James wrote: I'm having a bit of trouble with Page Styles and Fields in Writer. It's a pretty simple test file. The current page Field works the way I want but the page count Field is not what I want.

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread James
On 08/29/11 15:02, Cor Nouws wrote: Hi James, James wrote (29-08-11 20:16) I'm having a bit of trouble with Page Styles and Fields in Writer. It's a pretty simple test file. The current page Field works the way I want but the page count Field is not what I want.

Re: [libreoffice-users] Fedora 14 and Libreoffice

2011-08-29 Thread Cor Nouws
Hi Fabio, Fabio Andrijauskas wrote (28-08-11 23:45) I installed the LibreOffice 3.4.2 on Fedora 14, but when i start the software, the startup screen stops with the message Enabling: Report Builder What i can do to start the libreoffice ? Looks as if something goes wrong with trying

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread Steve Edmonds
Hi. On 30/08/11 8:14 AM, James wrote: On 08/29/11 15:02, Cor Nouws wrote: Hi James, James wrote (29-08-11 20:16) I'm having a bit of trouble with Page Styles and Fields in Writer. It's a pretty simple test file. The current page Field works the way I want but the page count Field is not what

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread Cor Nouws
James wrote (29-08-11 22:14) On the paragraph 'normal page' click Format Paragraph, tab tex flow and set the page number there to 1. I must have done that wrong because it made Page-Count=5. :-( Oh, sorry. It was my mistake. I thought you wanted to tweak the page number, not the page

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread Cor Nouws
Steve Edmonds wrote (29-08-11 22:26) No, I think you did it right as I get page count = 5 also. LO just can't count. I think what is required are some more statistics fields. Page Count is total pages, 4 was correct, 5 is definately wrong and so is 4 as there are only 3 pages. Thats a bug

[libreoffice-users] Re: trouble with Page Styles and Fields in Writer

2011-08-29 Thread NoOp
On 08/29/2011 01:12 PM, James wrote: On 08/29/11 15:39, webmaster for Kracked Press Productions wrote: On 08/29/2011 02:16 PM, James wrote: I'm having a bit of trouble with Page Styles and Fields in Writer. It's a pretty simple test file. The current page Field works the way I want but the

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread Brian Barker
At 16:12 29/08/2011 -0400, James Lockie wrote: There are 3 physical pages but I set the starting page# to 1 on the FirstPage so I expect Page-Count to start from there. There is no way it should even have Page-Count=4. At 08:26 30/08/2011 +1200, Steve Edmonds wrote: LO just can't count.

Re: [libreoffice-users] New to Group, and so checking on Browser Plug-in

2011-08-29 Thread Dave Barton
Original Message From: Tom Davies tomdavie...@yahoo.co.uk To: users@global.libreoffice.org Date: Mon, 29 Aug 2011 13:35:05 +0100 Hi :) If you open the manuals/guides by doing a right-click and then open in a new tab then you can give it plenty of time to open. The full

Re: [libreoffice-users] New to Group, and so checking on Browser Plug-in

2011-08-29 Thread webmaster for Kracked Press Productions
On 08/29/2011 07:35 PM, Dave Barton wrote: Original Message From: Tom Daviestomdavie...@yahoo.co.uk To: users@global.libreoffice.org Date: Mon, 29 Aug 2011 13:35:05 +0100 Hi :) If you open the manuals/guides by doing a right-click and then open in a new tab then you can give

Re: [libreoffice-users] New to Group, and so checking on Browser Plug-in

2011-08-29 Thread Dave Barton
Original Message From: webmaster for Kracked Press Productions webmas...@krackedpress.com To: users@global.libreoffice.org Date: Mon, 29 Aug 2011 20:21:04 -0400 On 08/29/2011 07:35 PM, Dave Barton wrote: Original Message From: Tom

Re: [libreoffice-users] trouble with Page Styles and Fields in Writer

2011-08-29 Thread James
On 08/29/11 19:05, Brian Barker wrote: At 16:12 29/08/2011 -0400, James Lockie wrote: There are 3 physical pages but I set the starting page# to 1 on the FirstPage so I expect Page-Count to start from there. There is no way it should even have Page-Count=4. At 08:26 30/08/2011 +1200, Steve

[libreoffice-users] Re: strikethrough in draw

2011-08-29 Thread NoOp
On 08/29/2011 03:24 AM, Andre wrote: Hi all, it seems like a simple question, but maybe not. In Draw, I want to strikethrough the text of a connector shape. I can choose the option from the context/character menu of the shape but nothing happens on the screen. Same with underlining. Has

[libreoffice-users] Re: Calc row filter extraction

2011-08-29 Thread Andreas Säger
Yes, I do agree But when there is only one table, Calc will do the job, no ? No need to use a hammer to slam a fly... Regards from Olivier That's why I linked a data pilot tutorial. Apart from that, a single table in a database is not a hammer and much easier to maintain in the long run (and

[libreoffice-users] No hatched cell background? Why?

2011-08-29 Thread Onyeibo Oku
In M$-Excel, cell backgrounds can be hatched. The printout is solid and that makes for nicer photocopied documents. LibO provides color backgrounds only. Is this by intention or are there plans to include that feature? For now - I gray-out cells that are usually hatched. Some photocoping

Re: [libreoffice-users] New to Group, and so checking on Browser Plug-in

2011-08-29 Thread Tom Davies
Hi :) Maybe about 5mins for the full book. On mine it took 15 seconds to reach the grey-out inside the tab and just under 30 seconds to display the Getting Started guide. More than 10secs feels like forever of course. The wiki-page shows the approximate number of pages in each guide