malfunzione

users
#1

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

#2

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

#3

Hi :slight_smile:
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

#4

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.

#5

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.

#6

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 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 37 28 29 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 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 37 28 29 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.

#7

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.

#8

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

#9

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 …

#10

Forgot the Reply To All thing again, sorry.