Re: [libreoffice-users] malfunzione
On Sat, 25 Jan 2014 09:27:33 +1000 Peter West li...@pbw.id.au wrote: Hello Peter, I can't see what you mean about having to squeeze an extra row (column?) onto the page. You have the same number of columsn whether you start at 31 or 1. Consider a 31 day month starting on Friday. It will end up looking like this; Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday 1 2 3 456 7 8 9 10 11 12 13 1415 16 17 18 19 20 2122 23 24 25 26 37 2829 30 31 Note that this takes six rows for the dates, but if the 31 is added at the top row, you only need five rows; Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday 31 1 2 3 456 7 8 9 10 11 12 13 1415 16 17 18 19 20 2122 23 24 25 26 37 2829 30 This increases the space available to users to write info, appointments etc. in each day, assuming each row is expanded slightly to fill the page. Admittedly, this might be of limited usefulness for a spreadsheet, but if the data gets printed to a sheet of paper, the extra space for each day's box often proves useful. It seems to me that the OP was worried about the layout unnecessarily, as the sheet's design must have taken the date ordering into account for performing any calculations. Of course, given that the original post was in a language I don't read, I may have missed some of the subtleties of that post as a result of working only from Tom's translation. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent If you ain't sticking your knives in me, you will be eventually Monsoon - Robbie Williams -- To unsubscribe e-mail to: users+unsubscr...@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] malfunzione
Thanks Brad, I follow that, but that doesn't seem to be what the OP was saying. Peter West ...for he had healed many, and all who had diseases pressed upon him, to touch him. On 25 Jan 2014, at 9:53 pm, Brad Rogers b...@fineby.me.uk wrote: On Sat, 25 Jan 2014 09:27:33 +1000 Peter West li...@pbw.id.au wrote: Hello Peter, I can't see what you mean about having to squeeze an extra row (column?) onto the page. You have the same number of columsn whether you start at 31 or 1. Consider a 31 day month starting on Friday. It will end up looking like this; Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday 1 2 3 456 7 8 9 10 11 12 13 1415 16 17 18 19 20 2122 23 24 25 26 37 2829 30 31 Note that this takes six rows for the dates, but if the 31 is added at the top row, you only need five rows; Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday 31 1 2 3 456 7 8 9 10 11 12 13 1415 16 17 18 19 20 2122 23 24 25 26 37 2829 30 This increases the space available to users to write info, appointments etc. in each day, assuming each row is expanded slightly to fill the page. Admittedly, this might be of limited usefulness for a spreadsheet, but if the data gets printed to a sheet of paper, the extra space for each day's box often proves useful. It seems to me that the OP was worried about the layout unnecessarily, as the sheet's design must have taken the date ordering into account for performing any calculations. Of course, given that the original post was in a language I don't read, I may have missed some of the subtleties of that post as a result of working only from Tom's translation. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent If you ain't sticking your knives in me, you will be eventually Monsoon - Robbie Williams -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] malfunzione
On Sat, 25 Jan 2014 22:40:13 +1000 Peter West li...@pbw.id.au wrote: Hello Peter, I follow that, but that doesn't seem to be what the OP was saying. In which case, I'm not fully understanding what the OP is asking for. As we say in these parts; I'll get my coat. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent I don't believe you have to be an idiot to get somewhere these days Bombsite Boy - The Adverts -- To unsubscribe e-mail to: users+unsubscr...@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] malfunzione
Note to the list admin: You need to put in a Reply-To: (maybe it's Reply To:) header specifying this list so that members who politely use Reply will send their replies to the list. Use of Reply All is often considered rude netiquette and ought not to be forced on people. === Now on to the topic at hand Being that this is an English language list and that the OP posted in Italian(?) [which was nicely translated for us by someone else] I'm wondering whether the OP is understanding the discussion. That said, I'm wondering if what is being displayed is 31 Dec, 1 Jan, 2 Jan, 3 Jan, … 30 Jan. This could be caused by displaying one value for each date in the month but starting with day zero instead of one. Just a thought … -- Jim -- To unsubscribe e-mail to: users+unsubscr...@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] malfunzione
La lingua ufficiale della lista a cui ha scritto è l'inglese. Il formato XLS è superato, non standard, non documentato, e sbaglia a gestire le date. Spesso, i problemi sono legati al formato XLS e non a LibreOffice (per esempio, XLS aggiunge un giorno che non è mai esistito per cui sballa tutte le date di un giorno: se il file di cui parla contiene questo bug - noto da 20 anni ma mai risolto - c'è poco da fare se non rifare il foglio elettronico con LibreOffice ed esportarlo in XLS). E' sicuro che il 31 in questione sia relativo a gennaio e non a dicembre? Sospetto che sia il 31 dicembre, proprio per il motivo che dicevo, ovvero che MS Office conta anche il 29 febbraio 1900 - che non è mai esistito - e LibreOffice non lo conta (nei fogli elettronici le date vengono trasformate in numeri assoluti, a partire dal 1 gennaio 1900, per cui si incappa spesso in questo problema). La lista non accetta allegati. Provi a scrivere alla mailing list utenti italiana, oppure alla comunità LibreItalia su Google+. On 24/01/14 11:47, Guglielmo Buzzulini wrote: vorrei segnalare il seguente problema : devo compilare un foglio ore mensile in formato excel (xls) , il foglio contiene l'elenco dei giorni disposti orizzontalmente ; all'apertura del foglio la colonna del primo giorno , anzichè contenere 1 , contiene l'ultimo giorno del mese , es. per gennaio 2014 trovo l'elenco seguente : 31 1 2 3 .. 30 in allegato vi invio il doc. come posso correggere il problema ? -- Italo Vignoli - italo.vign...@gmail.com mob +39.348.5653829 - sip/jabber it...@libreoffice.org skype italovignoli - hangout/jabber italo.vign...@gmail.com -- To unsubscribe e-mail to: users+unsubscr...@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] malfunzione
Hi :) A translation into English good day I would like to report the following problem: I have to fill out a monthly time sheet in excel format (xls), the sheet contains the list of days arranged horizontally; opening the sheet the column of the first day, rather than contain 1 contains the last day of the month, eg. for January 2014 I find the following list: 31 1 2 3 .. 30 in Annex I send the doc. how can I fix the problem? Regards 2014/1/24 Guglielmo Buzzulini buzzulini...@gmail.com: buon giorno vorrei segnalare il seguente problema : devo compilare un foglio ore mensile in formato excel (xls) , il foglio contiene l'elenco dei giorni disposti orizzontalmente ; all'apertura del foglio la colonna del primo giorno , anzichè contenere 1 , contiene l'ultimo giorno del mese , es. per gennaio 2014 trovo l'elenco seguente : 31 1 2 3 .. 30 in allegato vi invio il doc. come posso correggere il problema ? distinti saluti -- guglielmo buzzulini cell. 328-4850023 -- To unsubscribe e-mail to: users+unsubscr...@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] malfunzione
On Fri, 24 Jan 2014 16:14:31 + Tom Davies tomc...@gmail.com wrote: Hello Tom, the last day of the month, eg. for January 2014 I find the following list: 31 1 2 3 .. 30 in Annex I send the doc. how can I fix the problem? I see calendars done like that all the time; It saves having to squeeze an extra row onto a single sheet, or adding a sheet for just one day. In short, I don't see it as a problem at all. -- Regards _ / ) The blindingly obvious is / _)radnever immediately apparent Stained glass windows keep the cold outside Religion - Public Image Ltd -- To unsubscribe e-mail to: users+unsubscr...@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] malfunzione
On 25 Jan 2014, at 3:52 am, Brad Rogers b...@fineby.me.uk wrote: On Fri, 24 Jan 2014 16:14:31 + Tom Davies tomc...@gmail.com wrote: Hello Tom, the last day of the month, eg. for January 2014 I find the following list: 31 1 2 3 .. 30 in Annex I send the doc. how can I fix the problem? I see calendars done like that all the time; It saves having to squeeze an extra row onto a single sheet, or adding a sheet for just one day. In short, I don't see it as a problem at all. Brad, I can't see what you mean about having to squeeze an extra row (column?) onto the page. You have the same number of columsn whether you start at 31 or 1. Is Guglielmo saying that the Excel sheet starts at 1? Or is he just asking how to move the column? Peter West ...for he had healed many, and all who had diseases pressed upon him, to touch him. -- To unsubscribe e-mail to: users+unsubscr...@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