Narazil jsem na chybu v implementaci funkce DAY() v OpenOffice 1.1.4

policko  zapsano     format          zobrazi
B1       83:10:20    [HH]:MM:SS      83:10:20
B2       =DAY(B1)    Cislo|Standard  2 (!!! melo by zobrazit 3!!!)
B3       =HOUR(B1)   Cislo|Standard  11
B4       =MINUTE(B1) Cislo|Standard  20
B5       =SECOND(B1) Cislo|Standard  20

Viz prilozeny .sxc soubor. Pokud .sxc soubor vyexportuji do .xls a otevru v MS Excelu, vypocte a zobrazi se DAY v poradku (tj. 3).

Martin Poupa

--
===========================================================
 Ing. Martin Poupa, Ph.D.     University of West Bohemia
 http://home.zcu.cz/~poupa    Faculty of Electrical Eng.
 tel.: +420 377 634 239       Dept. of Applied Electronics
===========================================================

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Odpovedet emailem