...
With "Arbeitszeiten-vorlage-libreoffice6.ods" there are several issues, though:
- The IF formulas are always refering to row 1 or row 2, instead of to the same row containing the formula. I'll still have to check this. How did you create these formulas? By typing the first formula into the top-most cell and then dragging it down? In Excel this results in a "shared formula" which fpspreadsheet would not read for ods because I've never seen it there - but maybe they changed this in v6?
Are you saying cell I1 to i41?
Yes I created it so, writing in the top most cell then dragging it with mouse to bottom or copy/paste.
The Arbeitszeiten-vorlage-libreoffice6 from first post and also yours have no problem with rows when I open it with
spready*. It show (cell I10..I41) correct formulas and when i change values then
spready* calculates correct.
..
- The work times in columns E to H seem to be missing. But if you look at the cell editor you see the values. If you change the cell color they come up as well. The problem here is that these cells have a very unusual time formatting: LibreOffice displays the number format as "H:MM;@". Normally this means than positive values (part before the semicolon) will be formatted as "H:MM", and negative values (after the semicolon) will be formatted as text. But what does a "negative time" mean? How does a clock display a negative time? I think this is just nonsense. If you remove the ";@" and apply only the format "H:MM" then spready does display the work times correctly - see attached modified file. (Note that in spite of its extension this is an ods file. After saving, just remove the .zip extension by renaming).
I selected cell formats in Excel as time, 13:30. (Kategorie:'uhrzeit', Type:13:30)
In
Spready* color changing has no effect. It is visible when i select a format other then custom format. (i:e. Menu>Cell>Number format>short time)
Are you meaning with "negative time" the column "I" ("Stunden/Netto")? This column is formatted as decimal.
I selected red color for negative number to show false enterings.
When you enter for in-time 8:00 and out-time 7:00 then you have -1 Hour, because: 7-8=-1.
(It is not time as hours and minutes. i.e. 7,5 is 7 Hours and 30 Minutes.)
I think we should complete the Excel8-format. Because this format is completed and MS does not change it more. Plus all office applications can read this and write this format. Better one format completed as to many half implemented formats.
ODS or XLSX-Format are changing with new office versions, you will get often this problems.
*When I say here
spready then I mean compiled in octobre 5, 2017.