date:20120723

2012/7/22 webmaster-Kracked_P_P webmas...@krackedpress.com:

 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 printer/exported to PDF for distribution.  LO's
 Export to PDF, CUPS PDF printing for Linux, or doPDF PDF printing for
 Windows.

 The font installer, and other fonts software, is a good place to look at
 specialty fonts that might be used for your documents.  I used to use some
 really special ones from time to time, like letters made out of bone or
 other holiday related fonts.

 The core fonts that come with most MS systems, or the MS core font package
 for Linux, is just a start.  You really need to look at all of your options
 for typography of your documents.  Then using a PDF creation method, that
 embeds those fonts into your document, will make sure that your
 readers/users of those documents will see your work the way you want it to
 be seen.  LO does a good job with some of the popular fonts, but not as good
 on the decorative ones I tend to use.  That is where CUPS PDF and doPDF PDF
 printer software comes into play.  They will embed all of your specialty
 fonts into your documentation.  One day LO's Export to PDF will do that job
 as good as they do.

 As someone who download over 100,000 fonts from free font sites, I can tell
 you that there are many great looking fonts out there for your text and
 special documents that can be better than the MS core fonts.  All you have
 to do is take the time to look, download, and test some of them side to side
 with the MS core fonts.

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 characters in my
alphabet (those characters are real letters and they are not to be
treated as aAoO with some additional stuff above them – they are even
sorted as individual characters, that is not among aA and oO, but
right after zZ). I didn't investigate this very thoroughly, so I don't
know exactly how many of those millions of free fonts that lacks
essential characters for many of the top hundred common languages (my
language reached 77th place in 2009, according to this lisst:
http://frankherles.wordpress.com/2009/06/28/the-100-most-spoken-languages-on-the-world/)…

But as long as I write in English, this is of course not a problem,
but I almost never do that when I don't write in mailing lists like
this one…


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



 On 07/22/2012 01:50 PM, Jay Lozier wrote:

 On 07/22/2012 01:04 AM, Johnny Rosenberg wrote:

 2012/7/21 Anthony Easthope antiso...@myopera.com:

 Hi

 I was wondering what would be considered the core fonts on Microsoft.
 After  ages fruitless searching I was wondering if anybody could help me
 on what they would consider to be core fonts.
 I backed up my fonts folder from windows 7 before the change to ubuntu
 so I had all of them problem is I can not be bothered installing every
 single one of them!

 If you search for ttf-mscorefonts in Synpatic you might find them already
 installed. Also, you can install a font installer via Synaptic or the
 Software Center to install the fonts you backed up from Windows 7.

 The quickest way, if you want to install those mss TTF core fonts from
 the repositories, is from a terminal. Just copy this line into a
 terminal and hit Enter. Note that the keyboard shortcut for Paste is
 Ctrl+Shift+v, if you didn't edit those yourself:

 sudo apt-get install ms-corefonts-installer

 The package contains:
 Andale
 Arial Black
 Arial
 Comic Sans
 Courier New
 Georgia
 Impact
 Times New Roman
 Trebuchet
 Verdana
 Webdings

 If you only want to use Arial, Times New Roman and Courier New, it's
 recommended that you use the free fonts from the package
 fonts-liberation instead (probably already installed on your system.
 Those are called something like Liberation Sans (looks like Arial) and
 so on.



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ



 --

antiso...@myopera.com

 --
 For unsubscribe instructions e-mail to:
 users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted





 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this

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

2012/7/22 Andreas Säger ville...@t-online.de:
 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
 parameters in that range of cells.


 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ



 The advanced filter is documented. It reads filter criteria from cells
 rather than dialog or drop-downs.
 It uses the exact same type of criteria ranges as the database functions
 (DSUM, DCOUNT etc). You may refer to the filter documentation or D-function
 reference.

 Example file of mine: http://www.mediafire.com/view/?6vkfs9qq1qg666x

Okay, now I see. I used those D-functions in the past, so it's obvious
to me now. I totally misunderstood you last time. Thanks!


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Date format macro.

2012/7/22  rhubarbpie...@gmail.com:
 On 07/21/12 18:46, Dave Barton wrote:

  Original Message  
 From: rhubarbpie...@gmail.com
 To: Dave Barton d...@tasit.net
 Date: Sat, 21 Jul 2012 12:59:52 -0500

 On 07/21/12 00:45, Dave Barton wrote:

  Original Message  
 From: rhubarbpie...@gmail.com
 To: users@global.libreoffice.org
 Date: Fri, 20 Jul 2012 20:33:27 -0500

 On 07/20/12 02:16, Dave Barton wrote:

  Original Message  
 From: rhubarbpie...@gmail.com
 To: users@global.libreoffice.org
 Date: Thu, 19 Jul 2012 16:48:53 -0500

 I'd like to create a macro for a user-defined date format
 (H:MMa/p).  As
 examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
 create the format manually, but I understand the LibreOffice format
 can't save user-defined formats.  So my thought is to create a macro
 which creates the format each time the spreadsheet is opened.  The
 user-defined Format Code is for a saved Style.

 The macro records without incident and the date format is correct.
 However, running the saved macro doesn't change the format.  It seems
 this should work.  Thoughts?  The recorded macro is as follows:

 8-- code snip for brevity --8

 Sorry I can't help with your macro, but I like your idea.
 An alternative approach I use, is to add my user defined date format
 to
 my Calc default template.

 Dave

 Thank you for responding; I admire your style. I manually changed the
 date format of my spreadsheet, saved , then coded it as the default
 template. The default template took, but unfortunately, again the
 user-defined date format wasn't saved.

 Do I understand you can save a user-defined date format in the default
 template and it takes? I'm sure a macro would work and I can wade
 through the code, but if there's an easier way I'm interested.

 I am not sure what you mean by coded it as the default  template.
 If you follow this procedure:
 http://user.services.openoffice.org/en/forum/viewtopic.php?t=1161
 the .ots (Calc template) file will include your date format, as would
 be the case for any ODF file.
 I am sending you (off-list) an example template which has a DD.MM.
 date format, which is not included in standard list of date formats.
 Open it and you will find 31.12.1999 at the end of the Format = Date -
 Category format list.

 HTH

 Dave

 .

 Thank you again for responding.  However, I think we're talking apples
 and oranges.  I opened your template and the DD.MM. user-defined
 format works.  My problem is I can't get the H:MMa/p user-defined Format
 Code to take.  While the document is opened I can change 1:11PM to 1:11p
 for instance.  However, after saving, closing, and reopening the
 document the time appears as 1:11PM, not 1:11p, which is the format code
 I wanted saved.  I've always been able to save the user-defined code, I
 just can't get the lower-case a/p to take.  It does work with other file
 formats.

 That happens regardless of whether I save as an .ods or .ots file. I do
 see the user-defined Format Code, but it always comes up as H:MMAM/PM
 even though I save it as H:MMa/p.  I believe I originally created a
 default template correctly, but just redid the process with your
 instructions.  The same thing happens if I save the format in your
 attached template.

 So, can you successfully save the H:MMa/p format code?  That would
 address the apples/oranges question.  I'd appreciate your testing that
 if possible.  If it works for you I'm doing something wrong. It's not a
 huge deal to manually change AM/PM to a/p each time I open the
 spreadsheet, but not having to do so would be better.

 Your apples  oranges analogy is correct. I was misled by your
 original reference to Date format and although you spelled it out
 quite clearly I overlooked the fact that your issue was with Time
 format.

 I have now done some testing on this issue, with the following results:
 * Saving from LO in ODF (.ods or .ots) format does not preserve the
 user defined time format you want. (As you have already established.)
 * Saving from LO in Excel (.xls) format and reopening it LO does
 preserve the format. (As suggested by Pedro in another post to this
 thread.)

 It may or may not be of importance to you, but opening the files saved
 from LO and opening them in Excel 2010 I found:
 * XLS File: Partially preserves the time format (ie. H:MM), but the
 lower case p/m is becomes upper case P/M. The user defined cells are
 locked (MS terminology) and unlocking them the format changes to
 whatever MS deems to be appropriate.
 * ODF File: Generates an error, which Excel generously offers to fix,
 with the same result as for unlocking the cells in the XLS file.

 Unless someone with a better knowledge of Star Basic than myself can
 offer a solution to your macro problem, I suggest you file a bug/RFE
 issue. https://www.libreoffice.org/get-help/bug/

 Dave

 I understand your confusion as I should have titled the post Time format

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


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-complete function maintained the same
font-style when completing a word.

Is this a legitimate feature request?



 It already does this. For example, in a document I use both select and SELECT. [I 
have set the minimum word length to 6.] When I type SEL, it offers to complete it as 
SELECT. When I type sel, it offers to complete it as select. It does these two things 
because I have used both words in the document before.
 My settings in Tools  AutoCompletion Options  Word Completion tab: Enable word 
completion checked, Show as tip checked, Collect words checked, When closing a document 
... checked, Min. word length 6, and Max entries at 1000.
 The key may be that you have to have an entry in this list with the proper case 
before it will suggest it.
 I tested this using LO 3.4.6 and 3.5.5 on Ubuntu 12.04. LO downloaded from the the LO 
website.


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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ägerville...@t-online.de:

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 MRI inspector:


Sub Snippet(Optional oInitialTarget As Object)
   Dim oDatabaseRanges As Object
   Dim oObj_1 As Object
   Dim oFilterDescriptor As Object
   Dim oFilterFields As Object

   oDatabaseRanges = oInitialTarget.DatabaseRanges
   oObj_1 = oDatabaseRanges.getByIndex(0)
   oFilterDescriptor = oObj_1.getFilterDescriptor()

   oFilterFields = oFilterDescriptor.getFilterFields()
End Sub




And this is the output for oFilterFields:


(Name)(Value Type) (Value)  (AccessMode)
(0)
Connection.sheet.FilterConnection  AND  [ReadWrite]
Field long 0[ReadWrite]
Operator  .sheet.FilterOperatorEMPTY[ReadWrite]
IsNumeric boolean  True [ReadWrite]
NumericValue  double   0.0  [ReadWrite]
StringValue   string  [ReadWrite]
(1)
Connection.sheet.FilterConnection  OR   [ReadWrite]
Field long 0[ReadWrite]
Operator  .sheet.FilterOperatorEQUAL[ReadWrite]
IsNumeric boolean  False[ReadWrite]
NumericValue  double   0.0  [ReadWrite]
StringValue   string  [ReadWrite]



The blank field (0) uses c.s.s.sheet.FilterOperator.EMPTY with any content.
The empty string field (1) uses c.s.s.sheet.FilterOperator.EQUAL with string
content .


Thanks. I'll take a closer look at it tomorrow. Too tired and confused
right now.




Quite confusing, indeed. My Done posting refers to my other posting:


Am 20.07.2012 18:56, Johnny Rosenberg wrote:

2012/7/20 Andreas Sägerville...@t-online.de:

As far as I know, the find/replace tool can not find empty strings nor
blanks.
The standard filter can. It has an -- empty -- option for the blanks and
one empty entry at the end of the combo box for the empty strings (if any).


Can I use that in a macro? How?



Apply such filter manually and inspect the filter descriptor with its filter 
fields.


This is what I've done. I applied such a filter and ran MRI against the 
filter descriptor with the above results.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

2012/7/21 Manfred J. Krause courrier.oou.fr@googlemail.com

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:

a Scripting Framework error occurred while executing Basic script
vnd.sun.star.script:LibAnaphrase.Install.removeAnaphraseus
language=BasicLocation=application

Message: The following Basic script could not be found:
library: 'LibAnaphrase'
module: 'Install'
method: 'RemoveAnaphraseus'
location: 'application'

This window now appears every time I close a document...
How to get rid of Anaphraseus (it doesn't work anyway because pf some
conflict with Google Translate or such). [...]

Have a look at → 'Cannot uninstall Anaphraseus Extension'

http://ask.libreoffice.org/question/2855/cannot-uninstall-anaphraseus-extension-answered/

Hope this helps
mjk

Hi Manfred,

I tried this weekend to reach ask.libreoffice.org, but it was too busy. I
only succeeded to see the solutions you propose today. The 'uninstall'
option in the Anaphraseus menu doesn't seem to work. The 'uninstall' option
in the 'Readme_Eng' file gave the same error message as above. I also
clicked on the 'remove menu' button... surprise surprise, it now seems all
things Anaphraseus are gone.

thanks!
--
Guy
using LibO 3.6.0 on a iMac Intel DualCore Lion 10.7.4
-- please reply only to users@global.libreoffice.org --
Dodoes can't afford to have headaches

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Microsoft Core Fonts

2012-07-23 Thread webmaster-Kracked_P_P

On 07/23/2012 05:29 AM, Johnny Rosenberg wrote:
snip

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 characters in my
alphabet (those characters are real letters and they are not to be
treated as aAoO with some additional stuff above them – they are even
sorted as individual characters, that is not among aA and oO, but
right after zZ). I didn't investigate this very thoroughly, so I don't
know exactly how many of those millions of free fonts that lacks
essential characters for many of the top hundred common languages (my
language reached 77th place in 2009, according to this lisst:
http://frankherles.wordpress.com/2009/06/28/the-100-most-spoken-languages-on-the-world/)…

But as long as I write in English, this is of course not a problem,
but I almost never do that when I don't write in mailing lists like
this one…

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

snip

Yes, I will agree that most of the fonts out there are geared to the
English users.

There are sites and fonts out there geared for specific languages.
Finding a font that matches the special characters of a non-English
keyboard, Swedish, Hebrew, and other non-Latin glyph based characters is
a hard thing to do. Since I do not speak any other language than my
native English, I never really got into searching for foreign language
fonts. I do know that many of the free font sites do have a category or
two for non-English fonts. I just never looked deeply into those fonts.

Under your name, it looks like Hebrew glyphs. One of the things I
love about LibreOffice is the fact that it freely supports many
different languages for its menus and the ability to add languages to
its core package just be adding a language and help pack. Of course you
need to have fonts to work with that language, but that is a given.
Users of MSO have a problem if they want to switch between several
languages for their menus and such. I was told that you have to buy a
different version of MSO to have the other language as an option.

How many different languages do you use in your writing [not menus] of
documents with Writer? How easy it is to switch between languages?

The issue of free fonts that are a single language that is not English
is something that could be a problem for those of us in English speaking
countries that need to write documents in other languages that have
special characters/glyphs that are not the normal English keyboard
characters. The simple fact that in the US we have a requirement to
have government documents in both English and Spanish can cause problems
when you have an American English keyboard and you need to type in the
special characters that are common in Spanish and not on the normal
keyboards you buy in the US.

Here is the thing I am thinking about. I want to publish a list of
fonts with reference to similar fonts that may be used in place of the
first font name. I would love to list at least one alternative font
name that is available for free. Now if there are people out there who
could give the names of non-English fonts and names of fonts similar to
them, including any free fonts found that work in your native languages,
I would be pleased to add them to the list. Maybe divide the list into
language groups would work, though I do not know if the alternative font
lists names are associated with a non-English language or not. I am
just collating the documents I have found online into one large list. I
was thinking about having that list on a TDF/LO WIKI page as a free
service to our users. I would love to see users of a free alternative
to MSO use free fonts that are alternatives to paid version [whenever
there are not free versions of the named font in packages like
ttf-msfontcore-install for Linux]. Once such a list goes online, then
users can add font names to it, if and when they find a good font
substitute for a common font that your must buy.

Having people who are experienced in non-English languages and the font
names for those languages would be helpful in making the font list
useful for more than just English users.

If you or any other user would like to add to this font name project, I
hope to have something available online sometime in the next month or
so. I have a lot of pages of single-font-to-single-matching-font
listings to edit to one name with a list of all of the similar fonts I
have references to. Once I have edited the main document with enough
A-Z names, it will go online and will be updated as time go by.

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

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.
So instead of entering 20-7, I now need to enter 12-7-20 to get the desired
notation 20 Jul 12.

Is this a new feature, or a bug?

-- 
Guy
using LibO 3.6.0 on a iMac Intel DualCore Lion 10.7.4
-- please reply only to users@global.libreoffice.org --
Dodoes can't afford to have headaches

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Microsoft Core Fonts

2012/7/23 webmaster-Kracked_P_P webmas...@krackedpress.com:
On 07/23/2012 05:29 AM, Johnny Rosenberg wrote:
snip

http://frankherles.wordpress.com/2009/06/28/the-100-most-spoken-languages-on-the-world/)…

But as long as I write in English, this is of course not a problem,
but I almost never do that when I don't write in mailing lists like
this one…

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

snip

Yes, I will agree that most of the fonts out there are geared to the English
users.

There are sites and fonts out there geared for specific languages. Finding a
font that matches the special characters of a non-English keyboard, Swedish,
Hebrew, and other non-Latin glyph based characters is a hard thing to do.
Since I do not speak any other language than my native English, I never
really got into searching for foreign language fonts. I do know that many
of the free font sites do have a category or two for non-English fonts. I
just never looked deeply into those fonts.

Under your name, it looks like Hebrew glyphs.

It's supposed to be my name in Japanese, according to Google
Translate… I hope it's right, because I don't speak or write Japanese
(but I wish I could). I'm Swedish, actually, but my favourite band,
who are Americans (The Ventures), tour Japan a lot and many of their
records are made for the Japanese market, so there are a lot of
Japanese text on them, text that I can't read, unfortunately.

One of the things I love
about LibreOffice is the fact that it freely supports many different
languages for its menus and the ability to add languages to its core package
just be adding a language and help pack. Of course you need to have fonts
to work with that language, but that is a given. Users of MSO have a
problem if they want to switch between several languages for their menus and
such. I was told that you have to buy a different version of MSO to have
the other language as an option.

How many different languages do you use in your writing [not menus] of
documents with Writer? How easy it is to switch between languages?

I am not really a multi language guy. We all learn English at school
here, just like in most countries, I suppose, so for me it is maybe
99% Swedish and 1% English. In forums and mailing lists however, I
suspect that it is closer to 50% for both languages. I actually
learned German for two years at school, but since then (early 1980's)
I never used it for anything and I don't know any German people, so I
forgot most of it. I remember some of the grammatics and that nouns
always starts with a capital letter, and I remember a few words, but
not much more than that. I read somewhere that their ß character
(double s, like in ”straße”) is on its way out, but I'm not sure that
is true…

The issue of free fonts that are a single language that is not English is
something that could be a problem for those of us in English speaking
countries that need to write documents in other languages that have special
characters/glyphs that are not the normal English keyboard characters.
The simple fact that in the US we have a requirement to have government
documents in both English and Spanish can cause problems when you have an
American English keyboard and you need to type in the special characters
that are common in Spanish and not on the normal keyboards you buy in the
US.

Here is the thing I am thinking about. I want to publish a list of fonts
with reference to similar fonts that may be used in place of the first font
name. I would love to list at least one alternative font name that is
available for free. Now if there are people out there who could give the
names of non-English fonts and names of fonts similar to them, including any
free fonts found that work in your native languages, I would be pleased to
add them to the list. Maybe divide the list into language groups would work,
though I do not know if the alternative font lists names are associated with
a non-English language or not. I am just collating the documents I have
found online into one large list. I was thinking about having that list on
a TDF/LO WIKI page as a free service to our users. I would love to see
users of a free alternative

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

2012/7/23 Guy Voets nimant...@gmail.com:
 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.
 So instead of entering 20-7, I now need to enter 12-7-20 to get the desired
 notation 20 Jul 12.

 Is this a new feature, or a bug?

I am a user, not a developer, so I don't know for sure, but it looks
to me as a feature rather than a bug, or maybe a combination of both.
20-7-12 means 2020-july-12 (12th July 2020) according to ISO 8601, and
I guess it could be a point adapting to this international standard
(some countries already adapted most of ISO 8601, some of them decades
ago). Maybe this behaviour should be more dependent of the current
language settings?


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


 --
 Guy
 using LibO 3.6.0 on a iMac Intel DualCore Lion 10.7.4
 -- please reply only to users@global.libreoffice.org --
 Dodoes can't afford to have headaches

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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


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 inverted into 12 Jul 2020.
So instead of entering 20-7, I now need to enter 12-7-20 to get the desired
notation 20 Jul 12.

Is this a new feature, or a bug?


 I just downloaded LO 3.6.2 and installed it. Then I opened Calc. I also entered 20-7 
in a cell and got 20-7. It seems that Calc considered that to be text because the window to 
the right of the = was showing '20-7.
 Then I right clicked a column and formatted it using Dutch (Netherlands) as the 
local. I also selected 31 dec 99 from the format list. Then when I entered 20-7 I got 20 
jul 2012. 14-7 gave me 14 jul 2012.
 It may be a new feature in that you have to format cells, rows, or columns for the 
type of formatting you want in them.


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

2012/7/23 Johnny Rosenberg gurus.knu...@gmail.com

 2012/7/23 Guy Voets nimant...@gmail.com:
  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.
  So instead of entering 20-7, I now need to enter 12-7-20 to get the
 desired
  notation 20 Jul 12.
 
  Is this a new feature, or a bug?

 I am a user, not a developer, so I don't know for sure, but it looks
 to me as a feature rather than a bug, or maybe a combination of both.
 20-7-12 means 2020-july-12 (12th July 2020) according to ISO 8601, and
 I guess it could be a point adapting to this international standard
 (some countries already adapted most of ISO 8601, some of them decades
 ago). Maybe this behaviour should be more dependent of the current
 language settings?


 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ


Hi Johnny, thanks.

I get your point...
The language/country setting is Dutch/Belgium, which normally should give
20-7-2012, and I liked the practicality of just having to type 20-7 to get
this date entered in the spreadsheet.
I suppose I'll have to get used to the ISO standard behaviour.
-- 
Guy
using LibO 3.6.0 on a iMac Intel DualCore Lion 10.7.4
-- please reply only to users@global.libreoffice.org --
Dodoes can't afford to have headaches

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

Guy Voets wrote:
 2012/7/23 Johnny Rosenberg gurus.knu...@gmail.com
 
 2012/7/23 Guy Voets nimant...@gmail.com:
 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. So instead of 
 entering 
 20-7, I now need to enter 12-7-20 to get the
 desired
 notation 20 Jul 12.
 
 Is this a new feature, or a bug?
 
 I am a user, not a developer, so I don't know for sure, but it looks to me 
 as a 
 feature rather than a bug, or maybe a combination of both. 20-7-12 means 
 2020-july-12
  (12th July 2020) according to ISO 8601, and I guess it could be a point 
 adapting to 
 this international standard (some countries already adapted most of ISO 
 8601, some of
  them decades ago). Maybe this behaviour should be more dependent of the 
 current 
 language settings?
 
 
 Kind regards
 
 Johnny Rosenberg ジョニー・ローゼンバーグ
 
 
 Hi Johnny, thanks.
 
 I get your point... The language/country setting is Dutch/Belgium, which 
 normally should
 give 20-7-2012, and I liked the practicality of just having to type 20-7 to 
 get this
 date entered in the spreadsheet. I suppose I'll have to get used to the ISO 
 standard
 behaviour.

Looking at the date formats available for Dutch/Belgium, there is no DD-MM-JJ. 
If you
create a user defined format with this, you will be able to enter your dates as 
you always
have. You just have to format the cells or columns first using this format.

--Dan


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 I enter 20-7-12, the date is inverted into 12 Jul 2020.
So instead of entering 20-7, I now need to enter 12-7-20 to get the
desired
notation 20 Jul 12.

Is this a new feature, or a bug?


  I just downloaded LO 3.6.2 and installed it. Then I opened Calc. I
also entered 20-7 in a cell and got 20-7. It seems that Calc considered
that to be text because the window to the right of the = was showing '20-7.
  Then I right clicked a column and formatted it using Dutch
(Netherlands) as the local. I also selected 31 dec 99 from the format
list. Then when I entered 20-7 I got 20 jul 2012. 14-7 gave me 14 jul 2012.
  It may be a new feature in that you have to format cells, rows,
or columns for the type of formatting you want in them.

--Dan



And maybe is refined to be interpreted as date using the system 
separator, the same separator as in the date cell format.


In my Spanish Winx64Ult: /

If I enter: 20/7
I get: 20/07/12

If I enter: 20-7
I get: 20-7 (text)

Miguel Ángel

 * Inglés - detectado
 * Inglés
 * Español
 * Gallego
 * Italiano

 * Inglés
 * Español
 * Gallego
 * Italiano

 javascript:void(0);

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 nimant...@gmail.com

 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.
 So instead of entering 20-7, I now need to enter 12-7-20 to get the desired
 notation 20 Jul 12.

 Is this a new feature, or a bug?

 --
 Guy
 using LibO 3.6.0 on a iMac Intel DualCore Lion 10.7.4
 -- please reply only to users@global.libreoffice.org --
 Dodoes can't afford to have headaches

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

2012/7/23 Leif Lodahl leiflod...@gmail.com

 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.7.4
-- please reply only to users@global.libreoffice.org --
Dodoes can't afford to have headaches

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 :)  


--- On Mon, 23/7/12, MiguelAngel mari...@miguelangel.mobi wrote:

snip /

And maybe is refined to be interpreted as date using the system separator, the 
same separator as in the date cell format.

In my Spanish Winx64Ult: /

If I enter: 20/7
I get: 20/07/12

If I enter: 20-7
I get: 20-7 (text)

Miguel Ángel

 * Inglés - detectado
 * Inglés
 * Español
 * Gallego
 * Italiano

 * Inglés
 * Español
 * Gallego
 * Italiano

 javascript:void(0);

-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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-12, the date is inverted into 12 Jul 2020.
So instead of entering 20-7, I now need to enter 12-7-20 to get the desired
notation 20 Jul 12.

Is this a new feature, or a bug?



This is just another anti-feature that has been added to Calc against 
all reason simply because too many inexperienced users who never really 
used any spreadsheets insisted loudly enough.

I will upgrade my LibreOffice 3.5 to ApacheOpenOffice 3.4.1.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 ville...@t-online.de wrote:

From: Andreas Säger ville...@t-online.de
Subject: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation
To: users@global.libreoffice.org
Date: Monday, 23 July, 2012, 20:02

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-12, the date is inverted into 12 Jul 2020.
 So instead of entering 20-7, I now need to enter 12-7-20 to get the desired
 notation 20 Jul 12.

 Is this a new feature, or a bug?


This is just another anti-feature that has been added to Calc against 
all reason simply because too many inexperienced users who never really 
used any spreadsheets insisted loudly enough.
I will upgrade my LibreOffice 3.5 to ApacheOpenOffice 3.4.1.


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[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.
  Did you try the direct SQL mode (SQL view, menu:EditRun SQL directly)? If
  you get reasonable result in direct mode, it is one of many bugs in the
  Base's SQL parser.
 
  --
  View this message in context: 
  http://nabble.documentfoundation.org/SQL-statement-in-Base-query-tp3996273p3996282.html
  Sent from the Users mailing list archive at Nabble.com.
 
 
  That is the one thing that I forgot to mention: I get the same 
 message when using direct SQL mode. I even tried using Tools  SQL, but 
 with the same message.
 
 --Dan
 
 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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-7 is shown in the cell.

If I enter 20-7-12, the date is inverted into 12 Jul 2020.
So instead of entering 20-7, I now need to enter 12-7-20 to get the
desired
notation 20 Jul 12.

Is this a new feature, or a bug?



This is just another anti-feature that has been added to Calc against
all reason simply because too many inexperienced users who never really
used any spreadsheets insisted loudly enough.
I will upgrade my LibreOffice 3.5 to ApacheOpenOffice 3.4.1.


I resent the US way of ISO 8601. We Dutch and other Europeans use the 
more logical sequence of day-month-year instead of the illogical 
year-month-day.(most important first, least important last: very often 
the year can be missed).

Joep



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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


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 ends. So, I am not there 
quite yet. It seems that because Base uses HSQLDB 1.8, it does not 
conform with the user guide for the database engine it uses.
 When I get to that point, I will need to research how each of 
these backends use SQL.

--Dan



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.
Did you try the direct SQL mode (SQL view, menu:EditRun SQL directly)? If
you get reasonable result in direct mode, it is one of many bugs in the
Base's SQL parser.

--
View this message in context: 
http://nabble.documentfoundation.org/SQL-statement-in-Base-query-tp3996273p3996282.html
Sent from the Users mailing list archive at Nabble.com.



  That is the one thing that I forgot to mention: I get the same
message when using direct SQL mode. I even tried using Tools  SQL, but
with the same message.

--Dan








--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 jlb...@neuroweave.nl wrote:

From: Joep L. Blom jlb...@neuroweave.nl
Subject: Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation
To: users@global.libreoffice.org
Cc: Andreas Säger ville...@t-online.de
Date: Monday, 23 July, 2012, 22:18

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-7 is shown in the cell.

 If I enter 20-7-12, the date is inverted into 12 Jul 2020.
 So instead of entering 20-7, I now need to enter 12-7-20 to get the
 desired
 notation 20 Jul 12.

 Is this a new feature, or a bug?


 This is just another anti-feature that has been added to Calc against
 all reason simply because too many inexperienced users who never really
 used any spreadsheets insisted loudly enough.
 I will upgrade my LibreOffice 3.5 to ApacheOpenOffice 3.4.1.


I resent the US way of ISO 8601. We Dutch and other Europeans use the 
more logical sequence of day-month-year instead of the illogical 
year-month-day.(most important first, least important last: very often 
the year can be missed).
Joep



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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
  is
  done, especially for custom categories. I have basically 2 questions,
  listed at the end.
  
  I found
  http://wiki.documentfoundation.org/images/b/b1/Non-coding_extensions-
  final.odp from the LO Conference in Paris last year, from which I learnt
  that these are the built-in (as in: translated) categories:
  
  officorr → “Business Correspondence”
  offimisc → “Other Business Documents”
  personal → “Personal Correspondence and Documents”
  forms → “Forms and Contracts”
  finance → “Finances”
  educate → “Education”
  layout → “Presentation Backgrounds”
  presnt → “Presentations”
  misc → “Miscellaneous”
 
 Yes, those are defined in
 http://opengrok.libreoffice.org/xref/core/sfx2/source/doc/doctempl.src
 They are translated via the normal translation process via po-file.

Ah, good, thanks for the pointer. So labels is now actually also a built-in 
category, that is why it is translated.

  And to give custom categories nice names, one should put into the
  language
  or common directory a file .nametranslation.table which has
  folder=Name
  entries for all the custom category folders.
 
 There has also been a file groupuinames.xml in the template folder.

So seems .nametranslation.table is no longer used and now it's that 
groupuinames.xml, good hint, did not come across that before.

  Tried that but without success: I added a custom folder in
  /usr/share/templates/libreoffice/de named nametest, added a few
  templates
  there and put a file .nametranslation.table in
  /usr/share/templates/libreoffice/de, with this content
  --- 8 ---
  [TRANSLATIONNAMES]
  nametest=Naming Test
  --- 8 ---
  
  But as you can see in the attached screenshot, the folder only appears as
  nametest, not Naming Test.
  
  Q1: What am I doing wrong here? (LibreOffice 3.5.3.2 on openSUSE
  Tumbleweed)
  
  
  openSUSE by default also installed a package with labels, libreoffice-
  templates-labels-a4, which are placed in common/labels, so for the
  non-built- in category labels. Still the templates dialog has a full
  translated name for it, Etiketten.
  
  Q2: How does the custom category folder labels get its translation
  Etiketten?
 
 Have you already searched for Etiketten? That should find only few
 file candidates.

See, I was expecting labels to be a custom category, so looked at the wrong 
places :)

  No one here any clue? Do I better ask on the developer list?
 
 Yes. I guess you will deploy such a template package.
 
 If only you want a nice name, do not use the way to generate a new
 category via File  Templates  Organize. But simply create a sub-folder
 in the templates folder. It will be recognized when restart. The folder
 name is directly used as template category, at least on WinXP. Keep in
 mind, that sub-sub-folder is not possible.

Sure. Going via the filesystem directory name I was already successful in 
before, it was just that I was curious how translation works (for filesystems 
not okay with non-latin1 characters), in case I need it.

Thanks for your answers, have been helpful to me :)

Cheers
Friedrich

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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 think there is a coherent and consistent decision about the names
 chosen.  I can't really imagine the devs list being particularly interested
 or if they are their new choices might not be brilliant either. 
 
 It might be worth contacting the devs list to find out how to change the
 names and then perhaps join the docs team to find out if they have good
 naming schemes or even just a few good general ideas

Well, I have been basically curious how to do my own custom categories, not 
enforcing them on all LO users :)

 Just my 2cents as it sounds like you have a good plan already. 

Yes, and after Regina's reply an even better one. Still thanks for your 2cents 
:)

Cheers
Friedrich

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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

 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, 20/7/12 is the result.
 It is a matter of formatting the column, cell, or row for the type 
of data to be placed in the sheet. With the correct format 
[English(USA)], I can enter 20-7 in a cell, and it will become Saturday, 
July 20,2012 or Saturday, 20 July 2012 depending upon what format I use. 
(The last one would require selecting User-defined Category and the 
appropriate entries in the Format code box.)
 Ah yes, the weird USA way. While I had the Format dialog open 
with UK as the Language, I noticed something in the list of Format 
examples: MM-DD! If it should be DD/MM/YY, then why should it also be 
MM/DD? OK so the USA way is weird, but then so is the British. Check it 
out.  Chuckle, Chuckle! (From where this is located in the Format 
example list, I think I know why it is this way. (ISO 8601) But I could 
not resist replying to Tom's comment.


--Dan

Tom Davies wrote:

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 jlb...@neuroweave.nl wrote:

From: Joep L. Blom jlb...@neuroweave.nl
Subject: Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation
To: users@global.libreoffice.org
Cc: Andreas Säger ville...@t-online.de
Date: Monday, 23 July, 2012, 22:18

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-7 is shown in the cell.

If I enter 20-7-12, the date is inverted into 12 Jul 2020.
So instead of entering 20-7, I now need to enter 12-7-20 to get the
desired
notation 20 Jul 12.

Is this a new feature, or a bug?



This is just another anti-feature that has been added to Calc against
all reason simply because too many inexperienced users who never really
used any spreadsheets insisted loudly enough.
I will upgrade my LibreOffice 3.5 to ApacheOpenOffice 3.4.1.



I resent the US way of ISO 8601. We Dutch and other Europeans use the
more logical sequence of day-month-year instead of the illogical
year-month-day.(most important first, least important last: very often
the year can be missed).
Joep







--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

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, 2012 at 6:46 PM, Dave Barton d...@tasit.net wrote:


  From: rhubarbpie...@gmail.com
  To: users@global.libreoffice.org
  Date: Fri, 20 Jul 2012 20:33:27 -0500

 
  I'd like to create a macro for a user-defined date format
  (H:MMa/p).  As
  examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p.  I can
  create the format manually, but I understand the LibreOffice format
  can't save user-defined formats.  So my thought is to create a macro
  which creates the format each time the spreadsheet is opened.  The
  user-defined Format Code is for a saved Style.
 
  The macro records without incident and the date format is correct.
  However, running the saved macro doesn't change the format.  It seems
  this should work.  Thoughts?  The recorded macro is as follows:
 
  8-- code snip for brevity --8
  Sorry I can't help with your macro, but I like your idea.
  An alternative approach I use, is to add my user defined date format
 to
  my Calc default template.
 
  Dave
 
 
  Thank you for responding; I admire your style. I manually changed the
  date format of my spreadsheet, saved , then coded it as the default
  template. The default template took, but unfortunately, again the
  user-defined date format wasn't saved.
 
 
  Do I understand you can save a user-defined date format in the default
  template and it takes? I'm sure a macro would work and I can wade
  through the code, but if there's an easier way I'm interested.
  I am not sure what you mean by coded it as the default  template.
  If you follow this procedure:
  http://user.services.openoffice.org/en/forum/viewtopic.php?t=1161
  the .ots (Calc template) file will include your date format, as would
  be the case for any ODF file.
  I am sending you (off-list) an example template which has a DD.MM.
  date format, which is not included in standard list of date formats.
  Open it and you will find 31.12.1999 at the end of the Format = Date -
  Category format list.
 
  HTH
 
  Dave
 
  .
 
  Thank you again for responding.  However, I think we're talking apples
  and oranges.  I opened your template and the DD.MM. user-defined
  format works.  My problem is I can't get the H:MMa/p user-defined Format
  Code to take.  While the document is opened I can change 1:11PM to 1:11p
  for instance.  However, after saving, closing, and reopening the
  document the time appears as 1:11PM, not 1:11p, which is the format code
  I wanted saved.  I've always been able to save the user-defined code, I
  just can't get the lower-case a/p to take.  It does work with other file
  formats.
 
  That happens regardless of whether I save as an .ods or .ots file. I do
  see the user-defined Format Code, but it always comes up as H:MMAM/PM
  even though I save it as H:MMa/p.  I believe I originally created a
  default template correctly, but just redid the process with your
  instructions.  The same thing happens if I save the format in your
  attached template.
 
  So, can you successfully save the H:MMa/p format code?  That would
  address the apples/oranges question.  I'd appreciate your testing that
  if possible.  If it works for you I'm doing something wrong. It's not a
  huge deal to manually change AM/PM to a/p each time I open the
  spreadsheet, but not having to do so would be better.

 Your apples  oranges analogy is correct. I was misled by your
 original reference to Date format and although you spelled it out
 quite clearly I overlooked the fact that your issue was with Time format.

 I have now done some testing on this issue, with the following results:
 * Saving from LO in ODF (.ods or .ots) format does not preserve the
 user defined time format you want. (As you have already established.)
 * Saving from LO in Excel (.xls) format and reopening it LO does
 preserve the format. (As suggested by Pedro in another post to this
 thread.)

 It may or may not be of importance to you, but opening the files saved
 from LO and opening them in Excel 2010 I found:
 * XLS File: Partially preserves the time format (ie. H:MM), but the
 lower case p/m is becomes upper case P/M. The user defined cells are
 locked (MS terminology) and unlocking them the format changes to
 whatever MS deems to be appropriate.
 * ODF File: Generates an error, which Excel generously offers to fix,
 with the same result as for unlocking the cells in the XLS file.

 Unless someone with a better knowledge of Star Basic than myself can
 offer a solution to your macro problem, I suggest you file a bug/RFE
 issue. https://www.libreoffice.org/get-help/bug/

 Dave


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?

[libreoffice-users] Selecting fonts in Impress