[libreoffice-users] Re: Terrible problem with LibreOffice Word

2013-05-02 Thread Pedro
Unless it stopped working, here is the answer

http://nabble.documentfoundation.org/deleting-hard-returns-tt3541244.html#a3543444

Hope this helps :)



--
View this message in context: 
http://nabble.documentfoundation.org/Terrible-problem-with-LibreOffice-Word-tp4053247p4053296.html
Sent from the Users mailing list archive at Nabble.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



[libreoffice-users] Re: Terrible problem with LibreOffice Word

2013-05-02 Thread V Stuart Foote
Here are the LibreOffice specific reqular expressions and use cases:

 https://help.libreoffice.org/Common/List_of_Regular_Expressions




--
View this message in context: 
http://nabble.documentfoundation.org/Terrible-problem-with-LibreOffice-Word-tp4053247p4053318.html
Sent from the Users mailing list archive at Nabble.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



Re: [libreoffice-users] Writer - Spacing

2013-05-02 Thread Kracked_P_P---webmaster


Are you asking for:
specific paragraphs have the spacing?
specific lines within the paragraphs have the extra spacing?
specific highlighted single line of text, like paragraph headers, have 
the spacing?


I am not sure exactly what you want modified.



On 05/01/2013 11:54 PM, Brian Barker wrote:

At 22:58 01/05/2013 -0400, Charles Meyer wrote:
I see in Writer 3.6.2.2 under Paragraph you can change the spacing 
settings.


Line spacing is both a paragraph and a paragraph style property.

I've experimented with this without reaching my objective of changing 
the spacing from Single to something greater than single but less 
than 1.5.


Note that you are here presumably meaning proportions: by 1.5 you 
mean 50% more spacing than standard.


My goal is to create more space than single space between certain 
(but not all) lines of text throughput the document but I'm not sure 
how that can best (and easily) be done.


You may be certain about which lines you mean, but as yet no-one else 
is!  How you do this might depend on exactly how these lines are defined.


I've tried highlighting just the lines of text I want changed and 
then right clicking to Paragraph and then choosing At least 1.25 and 
it changes *all* the text in all the lines in the document. Same was 
true using Fixed and Proportional.


First, note that line spacing of At least refers to a distance, not 
a proportion, so 1.25 here would (unlike above) not mean 25% more 
than standard but 1.25 in whatever is your chosen measurement unit - 
centimetres, inches, or whatever.  If you want 25% more than standard, 
choose Proportional and 125% instead.


If this change affects all your text, then your entire document must 
be in one paragraph.  Divide your document into paragraphs (using 
Enter) and apply this change to the relevant paragraphs. Note that if 
you right-click and select Edit Paragraph Style... instead of 
Paragraph... you will affect all paragraphs in the same style as the 
current paragraph - and that may well include all your text in a 
simple but multi-paragraph document.


I'd appreciate your insight about how to change spacing text for just 
certain lines of text.


Divide your document so that the text that needs extra spacing is in 
separate paragraphs.  Either set the line spacing for these paragraphs 
to a larger value or - better still - create a paragraph style with 
extra line spacing and apply this style to the relevant paragraphs.


I trust this helps.

Brian Barker





--
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] Terrible problem with LibreOffice Word

2013-05-02 Thread Kracked_P_P---webmaster

On 05/02/2013 01:28 AM, Jeffrey Needle wrote:

I'm using the latest build of LibreOffice on a Linux box.

Here's my problem.  How do I use regular expressions to find hard carriage
returns at the end of lines?  I can find those created by using
shift-enter, using \n, but I don't see anything in the list of regular
expressions that lets me find hard returns.  Is there some code that should
be included in the list of regular expressions?

Thanks.





Have you looked at the document with
View Nonprinting Characters

That shows a lot of the things like the tab characterand the 
carriagereturnthat is withing the document.


They are not shown as the slash format, like the \n, \t, etc..

--
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] Terrible problem with LibreOffice Word

2013-05-02 Thread Jean-Francois Nifenecker

Le 02/05/2013 07:28, Jeffrey Needle a écrit :

I'm using the latest build of LibreOffice on a Linux box.

Here's my problem.  How do I use regular expressions to find hard carriage
returns at the end of lines?  I can find those created by using
shift-enter, using \n, but I don't see anything in the list of regular
expressions that lets me find hard returns.  Is there some code that should
be included in the list of regular expressions?



Regular expressions: checked

Find: $ will find any paragraph mark.
Find: ^$ will find empty paragraphs.

HTH,
--
Jean-Francois Nifenecker, Bordeaux

--
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: Odd problem LO with Mac running 10.7.5

2013-05-02 Thread Alexander Thurgood
Le 02/05/13 03:04, Richard Lewis a écrit :

Hi Richard,

 I'm creating instructional design to teach our 8th grade students how to
 use LibreOffice Impress.  However I'm running into a snag on my own Mac,
 developing the multimedia presentation.  The slideshow utilizes the
 Metropolis theme.  When I play the slide-show in full screen mode, only
 about 1/4 of the screen shows the blue background.  The rest of the
 background is white, and since the text is white it disappears.   I
 switched it to windowed mode to see if it made any difference.  The blue
 background still doesn't fill the slide area.  I've enclosed a jpg
 screen-shot of what it looks like.  Filename: LO_Problem.jpg
 

Where or what is the Metropolis theme ? Is it a background template for
Impress or have you taken it from some other app ? Any chance you could
post your presentation file somewhere so that others can test on their
own Mac hardware ?


Alex



-- 
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] Paragraph styles

2013-05-02 Thread Kevin O'Brien

On 4/30/2013 4:18 PM, Dave Liesse wrote:
As an end user, I'd like to ask one follow-up question to your third 
point.  This is an I don't understand type of question, by the way, 
not a challenge.


Are you implying that if I want to, say, indent one paragraph with no 
other changes, I should create a new style for that?  Seems like a lot 
of work since it can be done with one mouse clicks (or, if I ever get 
around to learning how to create shortcut keys, one keystroke 
combination) plus navigating to the paragraph.




Personally, I think this is the wrong way to approach the problem. I 
would start with *why* you want to indent the paragraph. What a lot of 
people do, without ever being conscious of it, is use visual appearance 
to communicate structural information. I start with the structural 
information (What is this object doing here on the page? What is its 
purpose?), and then I can add any visual formatting to it that I need. 
So if the indent is used to denote a quoted passage form another source 
(a very common usage), I would create a style for the *quotation*, and 
give it the attribute of indentation. And I would save it in my Default 
Template because I'm pretty sure this won't be the last time in my life 
that I need to do quoted passages. And if I have a long document with a 
number of objects, I can change the appearance of the quoted passages 
without affecting anything else. This is something the authors of the 
Writer documentation really understand, but it is a new way of thinking 
for most people.


Regards,

--
Kevin B. O'Brien
zwil...@zwilnik.com
A damsel with a dulcimer in a vision once I saw.


--
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: Paragraph styles

2013-05-02 Thread Alexander Thurgood
Le 30/04/13 21:40, Virgil Arrington a écrit :

Hi Virgil,

 4. Document collaboration is a real bugaboo. We lawyers share documents
 repeatedly. I would create a document using styles, and send it off to a
 colleague for further edits. I would get it back with a mess of styles
 and direct formatting. I see no answer to this conundrum, simply because
 our programs allow so many different ways of accomplishing the same
 tasks, and I couldn't expect a colleague to listen to my styles tutorial
 when all he wanted to do was make a small edit to my proposed contract.
 

Exactly. Try maintaining consistency when drafting a consortium contract
between 7 or 8 parties, using MS Word, LO or OOo, and see what the
document ends up like - a complete disaster !


Alex


-- 
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: Check Box size in LO Base

2013-05-02 Thread Alexander Thurgood
Le 30/04/13 12:43, Ian Whitfield a écrit :

Hi Ian,

 Is there a way of adjusting the size at all?
 

No, AFAIK this is an old nice-to-have feature from OOo days that was
never implemented. You are not the first to wish for it, nor I doubt,
the last. I'm not even sure now whether a bug report / feature request
has been filed for this in bugzilla.


Alex



-- 
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: Serious application development with LibreOffice and LibreOffice Basic

2013-05-02 Thread Alexander Thurgood
Le 28/04/13 02:53, Michael Lueck a écrit :

Hi Michael,


 I am interested in the capabilities of LibreOffice Basic along the same
 lines.

I seriously doubt that using LO Basic, you would be able to attain a
similar goal in any meaningful timeframe and with decent performance.
However, using another language via one of the UNO bindings might be a
more viable (if somewhat daunting) project.



 
 The documentation for LibreOffice Basic seems very space compared to MS
 VBA.

That's because it is. Documentation on UNO and Basic comes down to the
built-in help and anything you can find with regard to the
OpenOffice.org project, the current API documentation produced by the LO
project, and old Sun StarOffice documents (if they are still around).
VBA has a whole ecosystem and 20-odd years worth of product pushing
around it by people paid to push the platform forward. Although UNO has
been around since the days of StarOffice, it has never had that
commercial acceptance.

Look at UNO, look at the language bindings, decide which is the most
appropriate for what you want to do :

http://api.libreoffice.org/

http://api.libreoffice.org/docs/common/ref/com/sun/star/sdb/module-ix.html

http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbc/module-ix.html

http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbcx/module-ix.html


http://www.openoffice.org/udk/



Alex


-- 
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: Check Box size in LO Base

2013-05-02 Thread Alexander Thurgood
Le 30/04/13 12:43, Ian Whitfield a écrit :

Hi Ian,


 Is there a way of adjusting the size at all?
 

I'll try and find out on the dev list where the code responsible for
this might be (or might not be).

Alex



-- 
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: Check Box size in LO Base

2013-05-02 Thread Regina Henschel

Hi Alexander,

Alexander Thurgood schrieb:

Le 30/04/13 12:43, Ian Whitfield a écrit :

Hi Ian,



Is there a way of adjusting the size at all?



I'll try and find out on the dev list where the code responsible for
this might be (or might not be).


AFAIK, the checkbox is not self-drawn, but it is the native checkbox 
from the OS.


Kind regards
Regina


--
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: Check Box size in LO Base

2013-05-02 Thread Alexander Thurgood
Le 02/05/13 19:59, Regina Henschel a écrit :

Hi Regina,


 AFAIK, the checkbox is not self-drawn, but it is the native checkbox
 from the OS.

Thanks, that would explain why I could find no corresponding code in
AWT, in comparison to other elements of the toolkit. I've asked on the
dev list anyway, I would be interested whether this could be a do-able
easy hack. If the OS is called, then I guess everything currently goes
through VCL, which complicates matters somewhat.


Alex



-- 
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] Impress query

2013-05-02 Thread Brewster Gillett
Running LO 3.5.7.2 under Ubuntu 12.04

I've scoured the help, both internal and on-line. I've pored through
the FAQs. It may be that no such ability is provided with Impress.
But I'll ask in case someone here has done it:

How can I insert a live countdown clock display in my slides, tied to
the Advance slide Automatically after [ x seconds ] instruction?

IOW I set the above parameter to, say, 60 seconds. When the slide rolls
up, one corner of it has a prominent digital clock display reading
60 which proceeds to follow the timing downwards until it hits zero,
at which time the next slide rolls up and the process restarts.

If this feature is in Impress somewhere, I sure couldn't find it.

TIA,

Brewster

-- 
*
“The urge to save humanity is almost always a false front for the
 urge to rule.” 
H.L. Mencken
***
 W. Brewster Gillettb...@fdi.usPortland, OR  USA
***
 Simply because you don't like to hear it, that doesn't make it untrue.
***


-- 
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: Paragraph styles

2013-05-02 Thread Virgil Arrington

Alex wrote,


4. Document collaboration is a real bugaboo. We lawyers share documents
repeatedly. I would create a document using styles, and send it off to a
colleague for further edits. I would get it back with a mess of styles

and direct formatting. I see no answer to this conundrum, simply because
our programs allow so many different ways of accomplishing the same
tasks, and I couldn't expect a colleague to listen to my styles tutorial
when all he wanted to do was make a small edit to my proposed contract.




Exactly. Try maintaining consistency when drafting a consortium contract

between 7 or 8 parties, using MS Word, LO or OOo, and see what the
document ends up like - a complete disaster !

I never even try to share documents between different programs, such as Word 
and LO or OO. Even though they may be compatible, that is an relative 
concept. There are so many subtle difference between the way the programs 
handle document files that I found it futile to try to convert from one to 
the next. Thus, in my law office, my computer had Word, OpenOffice, and 
WordPerfect all installed. Even today, many lawyers still use WordPerfect, 
so I could adapt to whatever my counterpart was using.


Virgil 



--
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] Writer - Spacing

2013-05-02 Thread anne-ology
   If I understand what you're asking, this can be achieved either by
using BlockQuote or inserting a table;

  if this is to what you're referring and would like my
'programming', I'll be glad to send to you.

   [BTW - for you computerists, I keep all those tidbits in one page to
which I refer whenever making an HTML, ... document ...
  it's the KISs method again; not having to re-do what I've already
done  ;-)]



On Wed, May 1, 2013 at 9:58 PM, charles meyer reachmepl...@gmail.comwrote:

I see in Writer 3.6.2.2 under Paragraph you can change the spacing settings.

 I've experimented with this without reaching my objective of changing
 the spacing from Single to something greater than single but less than
 1.5.

 My goal is to create more space than single space between certain (but
 not all) lines of text throughput the document but I'm not sure how
 that can best (and easily) be done.

 I've tried highlighting just the lines of text I want changed and then
 right clicking to Paragraph and then choosing At least 1.25 and it
 changes *all* the text in all the lines in the document. Same was true
 using Fixed and Proportional.

 I have all the other settings in Paragraph spacing set to 0.00.

 I'd appreciate your insight about how to change spacing text for just
 certain lines of text.

 Thank you.

 Charles.



-- 
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] Just missed pre-release checksum

2013-05-02 Thread C. H. D.
Hi! I just could not get the checksum here:

http://download.documentfoundation.org/libreoffice/testing/4.0.3/deb/x86/LibreOffice_4.0.3.1_Linux_x86_deb.tar.gz.mirrorlist

or 


http://download.documentfoundation.org/libreoffice/testing/4.0.3/win/x86/LibreOffice_4.0.3.1_Win_x86.msi.mirrorlist

Please add them. Thanks a lot.

Best regards,
C. H. D.


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
-- 
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: Serious application development with LibreOffice and LibreOffice Basic

2013-05-02 Thread Andrew Douglas Pitonyak


On 05/02/2013 12:47 PM, Alexander Thurgood wrote:
I seriously doubt that using LO Basic, you would be able to attain a 
similar goal in any meaningful timeframe and with decent performance. 
However, using another language via one of the UNO bindings might be a 
more viable (if somewhat daunting) project. 


If you use another language, then you have full access to everything 
that it offers.



The documentation for LibreOffice Basic seems very space compared to MS
VBA.

That's because it is. Documentation on UNO and Basic comes down to the
built-in help and anything you can find with regard to the
OpenOffice.org project, the current API documentation produced by the LO
project, and old Sun StarOffice documents (if they are still around).
VBA has a whole ecosystem and 20-odd years worth of product pushing
around it by people paid to push the platform forward. Although UNO has
been around since the days of StarOffice, it has never had that
commercial acceptance.

Look at UNO, look at the language bindings, decide which is the most
appropriate for what you want to do :

http://api.libreoffice.org/

http://api.libreoffice.org/docs/common/ref/com/sun/star/sdb/module-ix.html

http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbc/module-ix.html

http://api.libreoffice.org/docs/common/ref/com/sun/star/sdbcx/module-ix.html


http://www.openoffice.org/udk/

I usually check the online API docs (as shown above), inspecting the 
objects, and I have even bothered to dive into the source code when I 
was totally befuddled.


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
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] Odd behavior using DATE() function in calc

2013-05-02 Thread vsharris
I have a spreadsheet with three columns: year, month, day.  In the 4th column
I use the DATE() function to create a date from these columns. It works fine
if there are valid data, but if the month and day column are empty, the
results are surprising.

For example:
  DATE(1995,blank,blank)
is the same as:
   DATE(1995,0,0)
which turns out to be:
30 Nov, 1994

I would rather the system generate an error warning (e.g., data out of
range) than silently produce a counter-intuitive result.

Am I missing something obvious here?

(config:
Xubuntu 12.04
LibreOffice 3.5.7.2
Build ID: 350m1(Build:2)
)



--
View this message in context: 
http://nabble.documentfoundation.org/Odd-behavior-using-DATE-function-in-calc-tp4053462.html
Sent from the Users mailing list archive at Nabble.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



Re: [libreoffice-users] Odd behavior using DATE() function in calc

2013-05-02 Thread Brian Barker

At 18:52 02/05/2013 -0700, V. S. Harris wrote:
I have a spreadsheet with three columns: year, month, day.  In the 
4th column I use the DATE() function to create a date from these 
columns. It works fine if there are valid data, but if the month and 
day column are empty, the results are surprising.


For example:
  DATE(1995,blank,blank)
is the same as:
   DATE(1995,0,0)
which turns out to be:
30 Nov, 1994


You seem to be equating empty with blank, which are not the same, but 
the results in this case are apparently the same for both.


I suppose this result is not particularly surprising.  If month one 
of 1995 is January, then month zero is December 1994; the zeroth of 
December will be the day before the first, so 30 November.


I would rather the system generate an error warning (e.g., data out 
of range) than silently produce a counter-intuitive result.


Am I missing something obvious here?


I think all you are missing is that in situations such as this it 
becomes your responsibility in designing the spreadsheet to cope with 
such problems.  If your first three columns of data are entered 
manually, you can arrange to restrict the values entered - but it may 
be difficult to cope with days that are generally valid but become 
invalid when interpreted in combinations with a month value.  31 is 
a valid day, of course, but not in combination with a month value of 
2, say.  But in any case, it would be silly to enter dates manually 
as three separate values like this; instead you should take advantage 
of the automatic date recognition of a spreadsheet and enter dates as 
a single value in a single cell.  If you need the separate parts, you 
can derive these from the single date value.


If - as is more likely - you are developing the values in the three 
columns from other data, then you should take care to trap 
exceptional cases, so that you do not hand empty, blank, or zero 
cells as parameters to the DATE() function.


Another possibility is that your data is created from another source, 
perhaps in the form of a CSV file or similar.  In that case, it is 
again your responsibility to build checks into the way you use the 
data.  You can use the IF() function to detect inappropriate data and 
to create the error messages you desire.


I trust this helps.

Brian Barker


--
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] Auto correct not work

2013-05-02 Thread Đạt Trần Quốc
Please help me. I use LibreOffice and ibus-unikey on ubuntu 13.04. I turn
off ibus-unikey, Capitalize first letter of sentences is work well. But I
turn on ibus-unikey, it don't work. I open docx, pptx file on LibreOffice
and they have page format error. Sorry, my English is bad.

-- 
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] BUG REPORT -- Version 4.0+ (Macbook Lion)

2013-05-02 Thread auto78240314
I have the latest 4.0+ version of Open Office, and see an unwanted 
popup when initializing the program.  This problem has been 
persistent since 3.0+, and was never corrected.  The popup shows up 
immediately, and gives you two options -- neither of which get rid 
of the popup after selecting them.  I am running the Macbook Lion, 
latest software update.
This bug has been in existence for at least 16 months.

Randal


-- 
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] BUG REPORT -- Version 4.0+ (Macbook Lion)

2013-05-02 Thread Joel Madero

On 05/02/2013 10:05 PM, auto78240...@hushmail.com wrote:

I have the latest 4.0+ version of Open Office, and see an unwanted
popup when initializing the program.  This problem has been
persistent since 3.0+, and was never corrected.  The popup shows up
immediately, and gives you two options -- neither of which get rid
of the popup after selecting them.  I am running the Macbook Lion,
latest software update.
This bug has been in existence for at least 16 months.

Randal


Bug reports should be reported to the official bug tracker - 
https://www.libreoffice.org/get-help/bug/. Developers and QA do not 
really follow this mailing list and will not triage nor fix bugs 
reported to it.


Attachments help tremendously for these kinds of issues.

Also, make sure to say LibreOffice and not Open Office when reporting ;)


Best,
Joel

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