Re: [libreoffice-users] Uninstall Anaphraseus (LibO 3.6 on Mac)

2012-07-23 Thread Mark Stanton
Anaphraseus not working? It *seems* to be working here, but that might be because I'm not sure what to expect from it. I, too, get the complaint on closing a document (which I've reported to the author), but it doesn't seem to cause a problem, does it? Regards Mark Stanton One small step for ma

Re: [libreoffice-users] Microsoft Core Fonts

2012-07-23 Thread Johnny Rosenberg
2012/7/22 webmaster-Kracked_P_P : > > I try to keep the same set of "core fonts" - not just MS core web fonts - on > all of my computers whether they are Windows or Ubuntu systems. I tend to > have over 100 fonts installed on these systems for greater flexability on > the look of my documents prin

Re: [libreoffice-users] Re: Filter rows of certain dates, LibreOffice Calc

2012-07-23 Thread Johnny Rosenberg
2012/7/22 Andreas Säger : > Am 22.07.2012 19:31, Johnny Rosenberg wrote: >> >> >> Thanks for the suggestion. However, I failed making it work. I tried a >> few different variations on that and either nothing happened at all, >> or I got an error message saying that there are no valid filter >> para

Re: [libreoffice-users] Date format macro.

2012-07-23 Thread Johnny Rosenberg
2012/7/22 : > On 07/21/12 18:46, Dave Barton wrote: >> >> Original Message >> From: rhubarbpie...@gmail.com >> To: Dave Barton >> Date: Sat, 21 Jul 2012 12:59:52 -0500 >> >>> On 07/21/12 00:45, Dave Barton wrote: Original Message From: rhubarbp

Re: [libreoffice-users] auto-complete font style

2012-07-23 Thread Dan
e-letter wrote: Readers, Is it possible to configure LO writer auto-complete function such that the font style is maintained? For example, the word 'explanation'. If the caps-lock is activated, the auto-complete offers to complete word in lower case: EXPLAnation It would be better if the auto

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-23 Thread Andreas Säger
Am 20.07.2012 21:37, Johnny Rosenberg wrote: 2012/7/20 Andreas Säger: Am 20.07.2012 14:19, Andreas Säger wrote: Try my "SpecialCells" extension which selects combinations of cell types: http://user.services.openoffice.org/en/forum/download/file.php?id=11048 Done. Snippet recorded by the M

Re: [libreoffice-users] Uninstall Anaphraseus (LibO 3.6 on Mac)

2012-07-23 Thread Guy Voets
2012/7/21 Manfred J. Krause > Hi Guy, > > On Sat, Jul 21, 2012 at 10:18 PM, Guy Voets wrote: > > Hi all, > > > > I installed 3.6.0.2 today, and have a problem with the Anaphraseus > > extension. > > The extension hasn't been working for some time, but now, I get a error > > message from LibO: > >

Re: [libreoffice-users] Microsoft Core Fonts

2012-07-23 Thread webmaster-Kracked_P_P
On 07/23/2012 05:29 AM, Johnny Rosenberg wrote: One big problem, for people like me whose native language is not English, is that many of those thousands of free fonts miss all language specific characters, in my case åäöÅÄÖ, characters that are just as common in my language as most of the other

[libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Guy Voets
Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12. - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell. If I enter 20-7-12, the date is inverted into 12 Jul 2020.

Re: [libreoffice-users] Microsoft Core Fonts

2012-07-23 Thread Johnny Rosenberg
2012/7/23 webmaster-Kracked_P_P : > On 07/23/2012 05:29 AM, Johnny Rosenberg wrote: > > >> One big problem, for people like me whose native language is not >> English, is that many of those thousands of free fonts miss all >> language specific characters, in my case åäöÅÄÖ, characters that are >>

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Johnny Rosenberg
2012/7/23 Guy Voets : > Hi folks, > > A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). > >- In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as >20 Jul 12. >- In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell. > > If I enter 20-7-12, th

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Dan
Guy Voets wrote: Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12. - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell. If I enter 20-7-12, the date is inver

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Guy Voets
2012/7/23 Johnny Rosenberg > 2012/7/23 Guy Voets : > > Hi folks, > > > > A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). > > > >- In LibO 3.5.5, I used to give in dates as 20-7 and they were shown > as > >20 Jul 12. > >- In LibO 3.6.0.2, if I enter 20-7, 20-7 i

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Dan
Guy Voets wrote: > 2012/7/23 Johnny Rosenberg > >> 2012/7/23 Guy Voets : >>> Hi folks, >>> >>> A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). >>> >>> - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown >> as >>> 20 Jul 12. - In LibO 3.6.0.2, if I enter

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread MiguelAngel
El 23/07/12 16:51, Dan escribió: Guy Voets wrote: Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12. - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell. If

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Leif Lodahl
Hi, The changed behavior cold be related to this feature: http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html Cheers, Leif Lodahl 2012/7/23 Guy Voets > Hi folks, > > A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). > >- In LibO 3.5.5, I used to

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Guy Voets
2012/7/23 Leif Lodahl > Hi, > The changed behavior cold be related to this feature: > http://erack.org/blog/archives/8-LibreOffice-date-acceptance-patterns.html > > > Cheers, > Leif Lodahl > > Thanks Leif, I'll try & adapt my behaviour... -- Guy using LibO 3.6.0 on a iMac Intel DualCore Lion 10.

Re: [libreoffice-users] LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Tom Davies
Hi :) I find that is often the way too.  It's a bit contra-intuitive to type-in a / when you know you want it to display a - and that makes it very hard to explain to people that need to enter data into your spreadsheet.  Saying it's the same in Excel doesn't help. Regards from Tom :)  --- O

[libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Andreas Säger
Am 23.07.2012 14:44, Guy Voets wrote: Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12. - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell. If I enter 20-7-

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Tom Davies
Hi :) Surely it's just a carelessness that can be undone? Is there a bug-report we can petition? Regards from Tom :)  --- On Mon, 23/7/12, Andreas Säger wrote: From: Andreas Säger Subject: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation To: users@global.libreoffice.org Date: Monda

[libreoffice-users] Re: Re: SQL statement in Base query

2012-07-23 Thread Ferry Toth
Did you try with another database as a backend? I like postgres as a backend a lot. Ferry Dan schreef op wo 18-07-2012 om 16:40 [-0400]: > Andreas Säger wrote: > > On this simple level I would consider HSQLDB as free of bugs whereas the > > primitive Base parser fails in many different ways. > >

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Joep L. Blom
On 23-07-12 21:02, Andreas Säger wrote: Am 23.07.2012 14:44, Guy Voets wrote: Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12. - In LibO 3.6.0.2, if I enter 20-7, 20-

Re: [libreoffice-users] Re: Re: SQL statement in Base query

2012-07-23 Thread Dan
Ferry Toth wrote: Did you try with another database as a backend? I like postgres as a backend a lot. Ferry I am writing a chapter of the Base Guide that includes using SQL in the Query Design dialog. Chapter 8 of the Base Guides covers using HSQLDB 2.2.8, MySQL, and PostgreSQL as back

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Tom Davies
Hi :) I thought the USA way was the amazingly weird mm/dd/yy Apparently it's important to use / instead of - in order to make sure it's easier to mis-read.  With some people's handwriting an 11 might look like 1/ or vice-versa.  Regards from Tom :)  --- On Mon, 23/7/12, Joep L. Blom wrote:

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Johnny Rosenberg
2012/7/23 Joep L. Blom : > On 23-07-12 21:02, Andreas Säger wrote: >> >> Am 23.07.2012 14:44, Guy Voets wrote: >>> >>> Hi folks, >>> >>> A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). >>> >>> - In LibO 3.5.5, I used to give in dates as 20-7 and they were >>> shown as >>

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Jay Lozier
On 07/23/2012 05:18 PM, Joep L. Blom wrote: On 23-07-12 21:02, Andreas Säger wrote: Am 23.07.2012 14:44, Guy Voets wrote: Hi folks, A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past). - In LibO 3.5.5, I used to give in dates as 20-7 and they were shown as 20 Jul 12

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Jay Lozier
On 07/23/2012 06:14 PM, Tom Davies wrote: Hi :) I thought the USA way was the amazingly weird mm/dd/yy It can tricky to enter dates as part of a file name in the US since / is reserved for use in OS path descriptions. Apparently it's important to use / instead of - in order to make sure it's

Re: [libreoffice-users] Which template categories are built-in, how to name custom ones?

2012-07-23 Thread Friedrich W. H. Kossebau
Hi Regina, Am Sonntag, 22. Juli 2012, 15:54:37 schrieb Regina Henschel: > Hi Friedrich, > > Friedrich W. H. Kossebau schrieb: > > Hi, > > > > Am Dienstag, 10. Juli 2012, 09:04:54 schrieb Friedrich W. H. Kossebau: > >> I need help with understanding how the naming of the template categories > >>

Re: [libreoffice-users] Which template categories are built-in, how to name custom ones?

2012-07-23 Thread Friedrich W. H. Kossebau
Hi Tom, Am Sonntag, 22. Juli 2012, 13:26:23 schrieb Tom Davies: > Hi :) > I think the Docs Team discussed the issue a couple of years ago but i think > changing it would be tons of hard work for very little gain. > > I think the names grew almost organically over the previous decade so i > don't

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Dan
Let me see: open Calc in LO 3.6.0.2 and format a column selecting the Category as Date and the Language as English(UK). It does not seem to matter what is selected as the Format. (I selected 31/12/99.) Enter 20-7 in a cell. It becomes 20/7/12. When 20/7 is entered in a cell of the column,

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread Dan
Dan wrote: Let me see: open Calc in LO 3.6.0.2 and format a column selecting the Category as Date and the Language as English(UK). It does not seem to matter what is selected as the Format. (I selected 31/12/99.) Enter 20-7 in a cell. It becomes 20/7/12. When 20/7 is entered in a cell of th

Re: [libreoffice-users] formatting

2012-07-23 Thread anne-ology
Is there some way, while in Impress, to make the desired font the default for that particular file? it's so frustrating to have to continually re-apply the text's font. I like to use differing fonts but within any one file, I want to use the same font. On Sat, Jul 21, 20

Re: [libreoffice-users] auto-complete font style

2012-07-23 Thread anne-ology
Should this work in MSFT Windows? - if so, could you please explain; it's frustrating to have to exit out of that box, erase the erroneous letters it placed in the document, then start again ... On Mon, Jul 23, 2012 at 6:02 AM, Dan wrote: e-letter wrote: > >> Readers, >> >> I

[libreoffice-users] Selecting fonts in Impress

2012-07-23 Thread Dan
Is there some way, while in Impress, to make the desired font the default for that particular file? It's so frustrating to have to continually re-apply the text's font. I like to use differing fonts but within any one file, I want to use the same font. --Anne-ology This had bee

[libreoffice-users] Do You Share ODF Documents With MS Office Users?

2012-07-23 Thread Don Parris
I would like to take something of a straw poll, if that's ok. I simply want to know whether any of you have shared documents using the ODF format with MS Office users (preferably in a business environment), and what was the reaction? What problems I am not seeking advice on how to share document

Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation

2012-07-23 Thread nvrk
On Mon, Jul 23, 2012 at 4:31 PM, Dan wrote: > Dan wrote: > >> Let me see: open Calc in LO 3.6.0.2 and format a column selecting >> the Category as Date and the Language as English(UK). It does not seem >> to matter what is selected as the Format. (I selected 31/12/99.) Enter >> 20-7 in a ce

[libreoffice-users] Where are my custom labels?

2012-07-23 Thread Libre User
I have recently upgraded to LibreOffice 3.6.4 and can't find my custom labels. Using the LO 3.2 family I have been creating labels for museum exhibits. From a museum supplied spreadsheet with the necessary fields, I used an LO Base query sheet and then used "Insert Labels". I created a custo

RE: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

2012-07-23 Thread Dennis E. Hamilton
I don't qualify for your use case. I use both ODF and OOXML and I use LibreOffice, Microsoft Office, and Apache OpenOffice (as well as some old OpenOffice.org versions). But my purpose is exploring interoperability available via the standardized formats. However, I can explain some of what yo

Re: [libreoffice-users] auto-text menu

2012-07-23 Thread Walther Koehler
Hallo List, using autotext extensively, I found that replacing an item is rather slow. One has to search the item to be replaced by mouse or repeated key strokes. It would be easier, to type the name or shortcut and have the item to be replaced marked in the list of exiting items. Find always t

Re: [libreoffice-users] formatting

2012-07-23 Thread Jean-Francois Nifenecker
Le 24/07/2012 01:56, anne-ology a écrit : Is there some way, while in Impress, to make the desired font the default for that particular file? it's so frustrating to have to continually re-apply the text's font. Yes, it is. The answer is: styles. In Impress, there are two s