[libreoffice-users] Re: Footnote references in Frames and/or Tables

2013-11-16 Thread CVAlkan
This is what I was trying to achieve: - --- --- === ---1--- ==2 - === - --- 1. 2. Body Text flowing as usual (illustrated by ---), with some sidebars (===), and with footnotes gathered at the bottom of each page (shown with ...).

[libreoffice-users] [Calc] Formula and Find Replace menu bar function

2013-11-16 Thread gordom
Hallo everyone. Some columns in my spreadsheet are filed with data only partly (some cells are blank). I need to put 0 value in this empty rows. Of course I can add an extra column and use a formula like this one for example =IF(ISBLANK(cell_address);0;cell_address) It works perfectly fine.

[libreoffice-users] SUMIF problem

2013-11-16 Thread John Meyer
=SUMIF(D1:D14,*Landline$,F1:F14) Will this match any text in D1 to D14 that ends with the word Landline? -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more:

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-16 Thread Kracked_P_P---webmaster
On 11/15/2013 05:17 PM, Paul wrote: On Fri, 15 Nov 2013 16:34:33 -0500 Kracked_P_P---webmaster webmas...@krackedpress.com wrote: On 11/15/2013 01:19 PM, Paul wrote: On Fri, 15 Nov 2013 18:06:05 + jonathon toki.kant...@gmail.com wrote: Sounds simple enough (and useful) to me, and I'm

[libreoffice-users] Re: SUMIF problem

2013-11-16 Thread Luuk
On 16-11-2013 16:08, John Meyer wrote: =SUMIF(D1:D14,*Landline$,F1:F14) Will this match any text in D1 to D14 that ends with the word Landline? no, because the criteria are wrong. But i dont know how to specify this the correct way, i only know a 'workaround'... If you add cells

Re: [libreoffice-users] Calc paste funnies

2013-11-16 Thread Paul
On Thu, 14 Nov 2013 22:24:51 +0100 Stefan Weigel stefan.wei...@bildungskreis.org wrote: Hi Paul, Am 14.11.2013 22:12, schrieb Paul: When I select copy, everything works as expected, the cell gets a dashed border. If I ctrl-v, it pastes. But if I right-click, there is no Paste or Paste

Re: [libreoffice-users] SUMIF problem

2013-11-16 Thread Mark Bourne
John Meyer wrote: =SUMIF(D1:D14,*Landline$,F1:F14) Will this match any text in D1 to D14 that ends with the word Landline? I think you want: =SUMIF(D1:D14,.*Landline$,F1:F14) (note the extra . before the *) In regular expressions, . matches any character, while * matches any number

Re: [libreoffice-users] [Calc] Formula and Find Replace menu bar function

2013-11-16 Thread Paul
Hi Gordom, On Sat, 16 Nov 2013 15:02:09 +0100 gordom gord...@wp.pl wrote: Hallo everyone. Some columns in my spreadsheet are filed with data only partly (some cells are blank). I need to put 0 value in this empty rows. Of course I can add an extra column and use a formula like this one for

[libreoffice-users] Error in loading LO 4.1.3

2013-11-16 Thread Bob Burr
I too have tried three times to download LO 4.1.3 en-gb. I am using Firefox and had no trouble in downloading previous versions. I don't understand « torrenting » and am not sure that I want to. If life is going to become as complicated as that then I would just as soon abandon LO and use

[libreoffice-users] RE: Base; Setting up relations between tables

2013-11-16 Thread Scott Castaline
I haven't worked with SQL DBs since the late 80's so I'm not sure what I'm doing wrong here. I have created a BASE DB using the internal HSQLDB engine for my music collection containing different media (CDs, DVDs, Vinyl LPs, 45s and Cassette, wife had thrown out all my 8-tracks back in '98 as

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-16 Thread jonathon
On 11/15/2013 10:17 PM, Paul wrote: That still doesn't make any sense. What is this theoretical 2000 page maximum? Unicode allows for 1,114,112 different glyphs, excluding variants. with variants, you are looking at roughly 1,750,000 glyphs. And why would the glyph's position be known?

[libreoffice-users] Re: SUMIF problem

2013-11-16 Thread Luuk
On 16-11-2013 17:52, Mark Bourne wrote: John Meyer wrote: =SUMIF(D1:D14,*Landline$,F1:F14) Will this match any text in D1 to D14 that ends with the word Landline? I think you want: =SUMIF(D1:D14,.*Landline$,F1:F14) (note the extra . before the *) In regular expressions, . matches any

Re: [libreoffice-users] RE: Base; Setting up relations between tables

2013-11-16 Thread Jay Lozier
On Sat, 2013-11-16 at 12:01 -0500, Scott Castaline wrote: I haven't worked with SQL DBs since the late 80's so I'm not sure what I'm doing wrong here. I have created a BASE DB using the internal HSQLDB engine for my music collection containing different media (CDs, DVDs, Vinyl LPs, 45s and

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-16 Thread jonathon
On 11/16/2013 08:17 PM, Paul wrote: Unicode allows for 1,114,112 different glyphs, excluding variants. with variants, you are looking at roughly 1,750,000 glyphs. And so... how does this relate to 2000 pages? The largest currently available Pan-Unicode font contains roughly 100,000 glyphs.

Re: [libreoffice-users] Feature Request - Categories for special characters

2013-11-16 Thread Paul
On Sat, 16 Nov 2013 21:59:04 + jonathon toki.kant...@gmail.com wrote: On 11/16/2013 08:17 PM, Paul wrote: Taking, thorn, for example, with the current setup, one knows to look in the Runic range. You might, but that doesn't mean everybody does. Only if one has paid absolutely no

Re: [libreoffice-users] Error in loading LO 4.1.3

2013-11-16 Thread Tom Davies
Hi :) By the sounds of it one of the mirrors is misbehaving. I'm not sure how to choose different mirrors but if you can then choosing a French one or any other non-default one might solve the problem. Hopefully the websites team might solve the problem fairly soon. My initial suggestions were

Re: [libreoffice-users] RE: Base; Setting up relations between tables

2013-11-16 Thread Scott Castaline
On 11/16/2013 02:25 PM, Jay Lozier wrote: On Sat, 2013-11-16 at 12:01 -0500, Scott Castaline wrote: I haven't worked with SQL DBs since the late 80's so I'm not sure what I'm doing wrong here. I have created a BASE DB using the internal HSQLDB engine for my music collection containing different

[libreoffice-users] Does someone have access to ftp server?

2013-11-16 Thread Joel Madero
Hi All, I'm hoping someone will grant me (or test for themselves) temporary ftp access to a server. https://bugs.freedesktop.org/show_bug.cgi?id=62981 I need to verify that this is still a problem with 4.1 - bug is super old and I'd like to just take care of it once and for all. I tried a