Bug#513349: openoffice.org-calc: OOcalc mishandling DAYS function

2009-02-01 Thread Rene Engelhard
found 2.0.2-1 forwarded http://qa.openoffice.org/issues/show_bug.cgi?id=63152 thanks Hi Eike, hi Marc, Eike Rathke wrote: > am Mittwoch, 2009-01-28 11:54:47 +0100, schrieb Marc Haber: > > > Enter "=days(A2;A1)" into A3 (resulting in -23) > > Save as Excel 97/2000/XP > > Close. > > Re-Open. > > S

Bug#513349: openoffice.org-calc: OOcalc mishandling DAYS function

2009-02-01 Thread Eike Rathke
moin Marc, am Mittwoch, 2009-01-28 11:54:47 +0100, schrieb Marc Haber: > Enter "=days(A2;A1)" into A3 (resulting in -23) > Save as Excel 97/2000/XP > Close. > Re-Open. > See "#MACRO?" error in A3. Excel doesn't have the DAYS() function, thus when saving to Excel binary format Calc has to workaro

Bug#513349: openoffice.org-calc: OOcalc mishandling DAYS function

2009-01-28 Thread Marc Haber
Package: openoffice.org-calc Version: 1:2.4.1-17 Severity: normal Start a new OOcalc Open a new Speadsheet Enter one date in A1 ("2009-01-20") Enter another date in A2 ("2008-12-28") Enter "=days(A2;A1)" into A3 (resulting in -23) Save as Excel 97/2000/XP Close. Re-Open. See "#MACRO?" error in A3.