https://bugs.documentfoundation.org/show_bug.cgi?id=170107
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Blocks| |94587 Keywords| |regression --- Comment #6 from ady <[email protected]> --- I have attached a basic test spreadsheet for DATEVALUE() (created with AOO 4.1.15, where it works as expected). 1. Open attachment 205165 2. Recalculate Hard (or Recalculate on cell E11, if the first is not available) Versions I tested (on Windows 10): DATEVALUE() OK (thus, probably a REGRESSION): _ ApacheOpenOffice 4.1.15 _ LibreOffice 3.3.0 DATEVALUE() fails on cell reference, but OK on direct text: _ LO 4.0.0.3 _ LO 5.0.6.3 DATEVALUE() fails on both, cell reference and on direct text: _ LO 6.0.4.2 _ LO 7.0.0.3 _ recent master of LO 26.8 Probably the same happens with VALUE(). It would be nice if someone (like Mike K.) could take a look at attachment 205165 as (one) example of formats that were supposed to work for DATEVALUE() (and VALUE()) according to ODF. When re-saving attachment 205165 as a different file with a recent LO master 26.8, and then checking it with odfvalidator: datevalue_lo268a.ods/content.xml[2,11088]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,11484]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,12968]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,13609]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,13928]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,14247]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,14790]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,15094]: Error: unexpected attribute "calcext:value-type" datevalue_lo268a.ods/content.xml[2,15574]: Error: unexpected attribute "calcext:value-type" among other odfvalidator errors. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=94587 [Bug 94587] [META] Properly support existing ODF features -- You are receiving this mail because: You are the assignee for the bug.
