Re: [libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-09 Thread Dan Lewis
On 09/09/2012 06:51 PM, JAMES MAJESKI wrote: In a spreadsheet I get all the information I require and it is easy to get additional information if needed. I can add, modify, and delete headers both horizontally and vertically. I can add, modify, or delete cells, rows, or columns at will. As long a

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-09 Thread JAMES MAJESKI
With the advice given earlier, I have found several methods that do what I need to get done with no problems. My previous lack of knowledge was easily corrected and I am confident in my ability to adapt the input to conform to the requirements of its intended function. Quote: [With US loale settin

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-09 Thread JAMES MAJESKI
When I change the file extension (file_name.ct2n), I find no difference in how the file is imported into a spreadsheet. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006429.html Sent from the Users maili

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-09 Thread JAMES MAJESKI
In a spreadsheet I get all the information I require and it is easy to get additional information if needed. I can add, modify, and delete headers both horizontally and vertically. I can add, modify, or delete cells, rows, or columns at will. As long as I leave the original data alone, I can add as

[libreoffice-users] Re: Base - creating an input mask for a postcode, telephone number, email address

2012-09-09 Thread Andreas Säger
Am 09.09.2012 21:17, naomi.br...@gmail.com wrote: Hi, I'm very new to Base, so any help is appreciated! I've created the fields postcode and email address, amongst others, and I want to create an input mask for each of them. I've started with the postcode mask, and entered AANNNAA and I've trie

[libreoffice-users] Re: Base Date issue

2012-09-09 Thread Andreas Säger
Am 09.09.2012 20:52, naomi.br...@gmail.com wrote: Hi, I've just had the same problem, I want to enter a year in the format , which I can't using the date/time field type. Having read this post I tried to choose an integer and have it set the length to 4, but it won't let me change the length

Re: [libreoffice-users] Re: Base Date issue

2012-09-09 Thread Dan Lewis
On 09/09/2012 02:52 PM, naomi.br...@gmail.com wrote: Hi, I've just had the same problem, I want to enter a year in the format , which I can't using the date/time field type. Having read this post I tried to choose an integer and have it set the length to 4, but it won't let me change the len

[libreoffice-users] Base - creating an input mask for a postcode, telephone number, email address

2012-09-09 Thread naomi.br...@gmail.com
Hi, I'm very new to Base, so any help is appreciated! I've created the fields postcode and email address, amongst others, and I want to create an input mask for each of them. I've started with the postcode mask, and entered AANNNAA and I've tried LLNNNLL in the field properties box but neither o

[libreoffice-users] Re: Base Date issue

2012-09-09 Thread naomi.br...@gmail.com
Hi, I've just had the same problem, I want to enter a year in the format , which I can't using the date/time field type. Having read this post I tried to choose an integer and have it set the length to 4, but it won't let me change the length of the integer. Any ideas? Thanks, Naomi -- Vi

[libreoffice-users] Re: Libreoffice and Java

2012-09-09 Thread V Stuart Foote
Tom wrote > > > So, i made the page > https://wiki.documentfoundation.org/Faq/Java > > I've cleaned up the FAQ/Java Wiki post on JRE 1.6.u35 and JRE 1.7u7 and Java Access Bridge configuration. My one continuing suggestion--have a single 32-bit JRE (1.6 or 1.7) configured for use with LibreOf

[libreoffice-users] Calc Chart is very slow when configuring a chart with large data sets

2012-09-09 Thread cs
Hello, I am running LibreOffice 3.5.4.2. My Operating System is Linux Mint 13. I am wondering if there is a way to disable the automatic updating/refreshing of the data in a chart while working on its properties. For example, I have a line chart with 1440 points. If I try and change a title, re

[libreoffice-users] DO NOT RESPOND TO ANY LINKS

2012-09-09 Thread Rich Johnson
I'm sorry, but I have been hijacked!! It will take me a little while to escape. First I guess I need a new PASSWORD, and I have never been very good (like, the WORST) at Scrabble. I don't even know HOW to put a link into an Email. Love, Rich -- For unsubscribe instructions e-mail to: user

[libreoffice-users] libreoffice hey

2012-09-09 Thread Rich Johnson
body{font-size:10pt;font-family:arial,sans-serif;background-color:#ff;color:black;}p{margin:0px;}libreoffice hi i took one look at this and i knew what i was going to be doing this is almost unbelievable at first http://j.mp/NiN8Rs -- For unsubscribe instructions e-mail to: users+h...@global

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-09 Thread Andreas Säger
Am 09.09.2012 11:54, Tinkerer wrote: Use the extension CT2N. It Converts Text to Numbers. Simples. Tink. Nobody needs to install any extension to convert between numbers and text. CT2N may fail in this situation (dmy vs. mdy). If all the dates have been imported as text, a simple regex re

Re: [libreoffice-users] calc - message in cell

2012-09-09 Thread Brian Barker
At 03:19 09/09/2012 -0700, Graham Lovatt wrote: Calc: How do i (can i) place in a cell a message - that isn't part of the active spreadsheet? I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing

Re: [libreoffice-users] calc - message in cell

2012-09-09 Thread Regina Henschel
Hi, IGraham schrieb: Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help Go to the

[libreoffice-users] Re: calc - message in cell

2012-09-09 Thread Andreas Säger
Am 09.09.2012 12:19, IGraham wrote: Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any hel

[libreoffice-users] Re: How to change Calc default to NOT add 1 when drag-copying a cell

2012-09-09 Thread Andreas Säger
Am 09.09.2012 07:32, Roger Davis wrote: How do I change the Calc default of adding 1 (+1) when a cell is drag-copied? I just want it to copy to the location(s) drug to, NOT add 1 to each cell in sequence. I know that holding CTL when doing this will prevent the addition, but I need this to be th

[libreoffice-users] calc - message in cell

2012-09-09 Thread IGraham
Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help - IGraham W764 LibreOffice

[libreoffice-users] Re: Was Re: Date will not format or sort when imported into calc (ods) - Databases vs Spreadsheets

2012-09-09 Thread Tinkerer
Use the extension CT2N. It Converts Text to Numbers. Simples. Tink. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4006356.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscrib

Re: [libreoffice-users] Formatting fonts in Impress

2012-09-09 Thread rost52
Let me add a comment to the one from Tom. I created my own Template and adjusted the fonts in the template. How to do? Create a presentation with the minimum slides you always want to have and adjust all to the layout you want to have. You will need to work in this case also with the Master Sli

Re: [libreoffice-users] custom shows within a slide show - impress

2012-09-09 Thread Dr. R. O Stapf
Hi and thanks for the first reply. I intend to show the custom show depending on the discussion in my (main) presentation. Imagine following sequence: - In my presentation I am showing slide N, - Because and only because of the discussion I want to show 2 slides additionally and then return to