[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 c

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

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 t

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

2013-11-16 Thread Paul
On Sat, 16 Nov 2013 21:59:04 + jonathon 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 attention to

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 glyph

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

2013-11-16 Thread Brian Barker
At 21:54 16/11/2013 +0200, Paul Steyn wrote: On Sat, 16 Nov 2013 19:35:53 + Brian Barker wrote: Some people think "~" is a tilde. (Hint: it's a swung dash.) Actually, it *is* a tilde (or at least looks identical to). The character I typed is mid-height and wouldn't fit over even a lowe

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

2013-11-16 Thread Regina Henschel
Hi, Brian Barker schrieb: At 17:35 16/11/2013 +, Toki "Jonathon" Kantoor wrote: Under what circumstances would one be using glyphs they know not the name of? Many people do not know the name "ampersand". No-one knows what "@" is called. Unicode has charts, where you can lookup the charac

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

2013-11-16 Thread Paul
On Sat, 16 Nov 2013 17:35:05 + jonathon wrote: > 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

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

2013-11-16 Thread Paul
On Sat, 16 Nov 2013 19:35:53 + Brian Barker wrote: > Some people think "~" is a tilde. (Hint: it's a swung dash.) Actually, it *is* a tilde (or at least looks identical to). See the section "Keyboards" here: http://en.wikipedia.org/wiki/Tilde My keyboard only has one such symbol on it tha

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

2013-11-16 Thread Brian Barker
At 17:35 16/11/2013 +, Toki "Jonathon" Kantoor wrote: Under what circumstances would one be using glyphs they know not the name of? Many people do not know the name "ampersand". No-one knows what "@" is called. Some people think "~" is a tilde. (Hint: it's a swung dash.) ;^) Brian Ba

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

2013-11-16 Thread Brian Barker
At 15:02 16/11/2013 +0100, Gordom Noname wrote: 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. [...] But I was wondering if this task can be accomplished without adding (even temporarily) additional column. o

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

[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

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? Tak

[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 w

[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 anoth

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 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 > examp

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 num

Re: [libreoffice-users] Calc paste funnies

2013-11-16 Thread Paul
On Thu, 14 Nov 2013 22:24:51 +0100 Stefan Weigel 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 Special", only "Paste

[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 G1.

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 wrote: > >> On 11/15/2013 01:19 PM, Paul wrote: >>> On Fri, 15 Nov 2013 18:06:05 + >>> jonathon wrote: >>> > Sounds simple enough (and useful) to me, and I'm not sure I agree > with e-le

[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: http://

[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] 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 ...). T