Re: Interesting interoperability problem with formatting of date

2014-01-10 Thread shzh zhao
in ooxml,there is a cache result for a formula, for example,1 in A1,2 in A2, A1+A2 in B1,then the xml will be 1 A1+A2 3 2 you can see the 3 is the cache result in MS office,this is important to interoperability or the computing speed. this value can be use to fix such issue. but in th

Re: Interesting interoperability problem with formatting of date

2014-01-10 Thread Rob Weir
On Fri, Jan 10, 2014 at 12:25 PM, Rory O'Farrell wrote: > On Fri, 10 Jan 2014 18:07:10 +0100 > Jürgen Schmidt wrote: > >> On 1/10/14 5:39 PM, Rob Weir wrote: >> > On Fri, Jan 10, 2014 at 11:12 AM, Jürgen Schmidt >> > wrote: >> >> Hi, >> >> >> >> I received a xls document with some date values,

Re: Interesting interoperability problem with formatting of date

2014-01-10 Thread Rory O'Farrell
On Fri, 10 Jan 2014 18:07:10 +0100 Jürgen Schmidt wrote: > On 1/10/14 5:39 PM, Rob Weir wrote: > > On Fri, Jan 10, 2014 at 11:12 AM, Jürgen Schmidt > > wrote: > >> Hi, > >> > >> I received a xls document with some date values, date related functions > >> and formatting and noticed an interestin

Re: Interesting interoperability problem with formatting of date

2014-01-10 Thread Rob Weir
On Fri, Jan 10, 2014 at 12:07 PM, Jürgen Schmidt wrote: > On 1/10/14 5:39 PM, Rob Weir wrote: >> On Fri, Jan 10, 2014 at 11:12 AM, Jürgen Schmidt >> wrote: >>> Hi, >>> >>> I received a xls document with some date values, date related functions >>> and formatting and noticed an interesting intero

Re: Interesting interoperability problem with formatting of date

2014-01-10 Thread Jürgen Schmidt
On 1/10/14 5:39 PM, Rob Weir wrote: > On Fri, Jan 10, 2014 at 11:12 AM, Jürgen Schmidt > wrote: >> Hi, >> >> I received a xls document with some date values, date related functions >> and formatting and noticed an interesting interoperability problem. >> >> For example: >> Cell Value

Re: Interesting interoperability problem with formatting of date

2014-01-10 Thread Rob Weir
On Fri, Jan 10, 2014 at 11:12 AM, Jürgen Schmidt wrote: > Hi, > > I received a xls document with some date values, date related functions > and formatting and noticed an interesting interoperability problem. > > For example: > Cell Value FormatVisible Value > A1 01/01/20

Re: Interesting interoperability problem with formatting of date

2014-01-10 Thread Herbert Duerr
On 10.01.2014 17:12, Jürgen Schmidt wrote: I received a xls document with some date values, date related functions and formatting and noticed an interesting interoperability problem. For example: Cell Value FormatVisible Value A1 01/01/2014 MM/DD/YY 01/01/2014

Interesting interoperability problem with formatting of date

2014-01-10 Thread Jürgen Schmidt
Hi, I received a xls document with some date values, date related functions and formatting and noticed an interesting interoperability problem. For example: Cell Value FormatVisible Value A1 01/01/2014 MM/DD/YY 01/01/2014 A2 =DAY(A1) DD3