Re: [libreoffice-users] Re: calc

2012-09-13 Thread Dr. R. O Stapf
I indeed understood that you want to show the y-value of every fifth x-value. However, it seems you don't want to stick with the pattern but want to be more flexible. In general a graph displayes the correlation between a series of x-values and their related y-values. The x-axis is in any spree

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

2012-09-13 Thread JAMES MAJESKI
I have several solutions to the original problem. I have explored the database option. I wish to thank everyone for their contributions. I am very happy with the results. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-ca

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

2012-09-13 Thread JAMES MAJESKI
Andreas Säger wrote: *Because* spreadsheets are so flexible you can not edit databases with them. Simply because all you have is a database excerpt in plain text. You never asked for flexibility. You asked for data integrity (keep the exact same date encoding when saving back to a database file).

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

2012-09-13 Thread Tom Davies
Hi :) Ahhh, we shorten MS Office to MSO.  It might be only LibreOffice lists and a few other such places that use it that way. Regards from Tom :)  > > From: JAMES MAJESKI >To: users@global.libreoffice.org >Sent: Thursday, 13 September 2012, 4:03 >Subject: [

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Tom Davies
Hi :) +1 Do you delete cookies, temp-files, history, cache, desktop.ini, thumbnails and so on too?  It all seems too much effort and too likely to create problems.  Regards from Tom :)  > > From: Dan Lewis >To: users@global.libreoffice.org >Sent: Thursday,

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Tom Davies
Hi :) Good back-up processes 'should' exclude anything that has not changed.  That is they 'should' be able to identify which files and folders have changed with a reasonable level of accuracy.  Like syncing process are meant to do.  Grsync is quite nice.  If you are happy on the command-line

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Dries Feys
IMHO, why don't you exclude the dot-files from the backup? The really important dot-system files can then be another exception on the exclusion exception (opt-in) Met vriendelijke groeten, Cordialement, Regards, DRIES FEYS CORPORATE SERVICES • Senior Software Engineer On 13 September 2012 16:4

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread John Clegg
Could you just not exclude this directory from the backup? On 13 September 2012 15:29, Enda wrote: > When I backup all the files, I like to see which files are being backed > up, if the folder has changed (by having a file created and deleted) I see > this folder I when I backup. I would rather

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Enda
There are many directories (and if the file has changed, I want it backed up), is there a way to stop creating dot files? - Enda From: John Clegg To: Enda Cc: Dan Lewis ; "users@global.libreoffice.org" Sent: Thursday, September 13, 2012 3:35 PM Subject:

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Jay Lozier
On 09/13/2012 10:00 AM, Enda wrote: > I am the only user on the system. When I view a file, a dot file (like > .~lock.file.doc#) is created. How can I override (stop) this in LibreOffice? > > > - Enda Normally the lock file (.lock, .doc~) is created to prevent multiple users from updating the same

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Enda
When I backup all the files, I like to see which files are being backed up, if the folder has changed (by having a file created and deleted) I see this folder I when I backup. I would rather not see folders that have not really changed. (I am not trying to open the file more than once.)  - En

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Dan Lewis
What does it prevent you from doing? Are you trying to open this file more than once? You see, I'm confused why you need to override this function of LO. Since the dot files are hidden anyway, I don't see what difference the existence of these files make. The answer to my questions might enligh

Re: [libreoffice-users] Re: not create a dot file in same folder as document when opening it for viewing

2012-09-13 Thread Enda
I am the only user on the system. When I view a file, a dot file (like .~lock.file.doc#) is created. How can I override (stop) this in LibreOffice? - Enda - Original Message - From: Jay Lozier To: users@global.libreoffice.org Cc: Sent: Wednesday, September 12, 2012 3:33 PM Subject:

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

2012-09-13 Thread Andreas Säger
Am 10.09.2012 22:30, Andreas Säger wrote: Am 10.09.2012 19:40, Andreas Säger wrote: Base is our database component. It is very, very underdeveloped, nevertheless underestimated. Even the worst database tool does a better database job than the best spreadsheet can do. Since nobody ever uses

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

2012-09-13 Thread Andreas Säger
Am 13.09.2012 11:54, Andreas Säger wrote: Am 13.09.2012 05:03, JAMES MAJESKI wrote: My only queries of the data are handled adequately by the calculations done in adjacent columns. Nothing special, complex, or complicated will easily replace it nor be more useful. Calc can do all this without

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

2012-09-13 Thread Andreas Säger
Am 13.09.2012 05:03, JAMES MAJESKI wrote: My only queries of the data are handled adequately by the calculations done in adjacent columns. Nothing special, complex, or complicated will easily replace it nor be more useful. Calc can do all this without very easily with the help of the Base com

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

2012-09-13 Thread Andreas Säger
Am 13.09.2012 05:18, JAMES MAJESKI wrote: So far nobody has come up with a reason for me to switch to a database where I risk loosing data if I attempt to make a change to the layout. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-impor

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

2012-09-13 Thread Andreas Säger
Am 13.09.2012 00:49, JAMES MAJESKI wrote: Name one feature that makes a database better than a spreadsheet when flexibility of input is required. -- View this message in context: http://nabble.documentfoundation.org/Date-will-not-format-or-sort-when-imported-into-calc-ods-tp4004907p4007128.ht

Re: [libreoffice-users] Re: calc

2012-09-13 Thread a a
i think i get how you mean, if i understand you right using your method will get me one bar on 0, one bar on 5, one bar on 10 etc. I want the bars to be on varius places on the x.axel depending on the chart i am doing, but i want only to see every fifth number on the x-axel line. For example say i

Re: [libreoffice-users] Re: calc

2012-09-13 Thread rost52
Now I understand you. Im afraid there is not such a solution you are looking for. Charts in general are based on a defined data range for the x-axis where all data on this range are includeded. But you want to make a data selection using a chart. You real task, the seclection of data (your x-ax

Re: [libreoffice-users] Re: calc

2012-09-13 Thread a a
ok now to the problrm in detail, In the original file that i want to change, i have numbers 1-35 on the x-axel, which all shows in the diagram, What i now want is to show only every 5 numbers (0.5.10 etc) so its easier to read the chart. in pic Y-axel, i can change max/minimum range , intervalls be

Re: [libreoffice-users] Re: calc

2012-09-13 Thread rost52
I am not sure if i understand your problem correct but try to give you and answer based on my understanding. I you want to change the range for the x-axis you need (also in MS Excel) to change the range and you cannot do this in the window (X-axis) you opened, You must expand you x-axis data ra

Re: [libreoffice-users] Re: calc

2012-09-13 Thread a a
I am now sending 2 pics, first shows how i want it, Where i can change the values, (Y-axel) Second file is the malfuncional one? (X-axel) When i do same thing on another computer i get Y-axel choices in grey, when i try the x-axel ,which doesnt allowe me to change the values. On this comp i get wha

Re: [libreoffice-users] Re: calc

2012-09-13 Thread rost52
Yes do so. All addtional information can help. On 2012-09-13 15:45, a a wrote: Ty for all help, but i want to make a bar diagram X/Y wise. Should i send a screenpic of the grey area and the diagram? Sometimes a pic can tell more then text. /Magnus 2012/9/12 MiguelAngel El 12/09/12 16:26, And

Re: [libreoffice-users] Re: Automatically fill user informations from Sun LDAP

2012-09-13 Thread Nicolas ABEL
Hi everybody. First of all, I'm sorry for the lack of informations; i'm going to explain a bit more. Yes, Alexander and Andreas, you got it. On 300 computers, I'd like to fill automatically the informations contained in LibreOffice "Tools>Options>User Data" (because they are the one kept up