Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Update HLOOKUP, LINEST, LOGEST, MATCH and VLOOKUP.

...

TopicDeveloperStatusBZ ID / Git commitComment

<dsig:document-signatures> 5.2 Office-3869


Status
colourRed
titleOPEN



<ds:signature> 5.3 Office-3870


Status
colourRed
titleOPEN



<ds:signature> 5.3 Office-3871


Status
colourRed
titleOPEN



<manifest:algorithm> 4.5 Office-3859


Status
colourRed
titleOPEN



Encryption-General 3.4.1 Office-3875


Status
colourRed
titleOPEN



List of all changes in ODF 1.3 part 3

...

TopicDeveloperStatusBZ ID / Git commitComment
Change Tracking General 5.5.1 Office-3873

Status
colourRed
titleOPEN



Document Fields – General 7.3.1 Office-3783

Status
colourGreen
titleCLOSED


Just a typo.

Drawing Page Style 16.41 Office-3937


Status
colourRed
titleOPEN



Foreign elements and attributes 3.17 Office-3950 , Office-4034


Status
colourRed
titleOPEN



List Item Style Rules 5.3.5 Office-3782


Status
colourRed
titleOPEN



Normative References 1.3 Office-3868


Status
colourRed
titleOPEN



Open Document Drawing Document 2.2.5 Office-3744

Damjan Jovanovic 

Status
colourRedGreen
titleOPEN

Open Document Drawing Document 2.2.5 Office-3746

CLOSED


ODF 1.2 incorrectly stated the MIME type is "application/vnd.oasis.opendocument.graphic-template" instead of "application/vnd.oasis.opendocument.graphics-template". We only use the correct MIME type, there is no mention of the wrong one on OpenGrok.

Open Document Drawing

Status
colourRed
titleOPEN

OpenDocument Text Document 2.2.35 Office-25803746

Damjan Jovanovic 

Status
colourRedGreen
titleOPENCLOSED


ODF 1.2 uses "application.vnd.oasis.opendocument.graphics" instead of "application/vnd.oasis.opendocument.graphics". We only use the correct MIME type, there is no mention of the wrong one OpenGrok.

OpenDocument Text Document 2.2.3 Office-2580Styles General 3.15.1 Office-3697


Status
colourRed
titleOPEN



White Space Characters 6Styles General 3.15.1.2 Office-21023697

Damjan Jovanovic 

Status
colourRedGreen
titleOPENCLOSED


Just a change to a cross-reference.

White Space Characters 6.1.2 Office-2102


Status
colourRed
titleOPEN



White Space Processing White Space Processing and EOL Handling 3.18 Office-2102

Status
colourRed
titleOPEN



...

TopicDeveloperStatusBZ ID / Git commitComment

<chart:legend> 11.4 Office-3883


Status
colourRed
titleOPEN



<config:config-item-set> 3.10.2 Office-3684


Status
colourRed
titleOPEN



<draw:applet> 10.4.7 Office-2044

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


<draw:applet> is deprecated. It's still supported by us.

<draw:fill-image> 16.42.6 Office-3933


Status
colourRed
titleOPEN



<draw:image> 10.4.4 Office-3922


Status
colourRed
titleOPEN



<dr3d:scene> 10.5.2 Office-3932


Status
colourRed
titleOPEN



<number:date-style> 16.29.11 Office-1832


Status
colourRed
titleOPEN



<number:fill-character> 16.29.1 Office-3765


Status
colourRed
titleOPEN



<number:fraction> 16.29.7 Office-3695


Status
colourRed
titleOPEN



<number:number> 16.29.3 Office-3860


Status
colourRed
titleOPEN



<number:scientific-number> 16.29.6 Office-3860


Status
colourRed
titleOPEN



<office:automatic-styles> 3.15.3 Office-3683


Status
colourRed
titleOPEN



<style:default-page-layout> 16.8 Office-3696


Status
colourRed
titleOPEN



<style:drawing-page-properties> 17.25 Office-3937


Status
colourRed
titleOPEN



<style:master-page> 16.9 Office-3679


Status
colourRed
titleOPEN



<style:style> 16.2 Office-3935


Status
colourRed
titleOPEN



<style:tab-stops> 17.7 Office-3845


Status
colourRed
titleOPEN



<style:text-properties> 16.29.29 Office-3895


Status
colourRed
titleOPEN



<table:covered-table-cells> 9.1.5 Office-3877


Status
colourRed
titleOPEN



<table:source-cell-range> 9.6.5 Office-3665


Status
colourRed
titleOPEN



<table:table-columns> 9.1.12 Office-3839


Status
colourRed
titleOPEN



<table:table-rows> 9.1.8 Office-3838


Status
colourRed
titleOPEN



<text:numbered-paragraph> 5.3.6 Office-1437


Status
colourRed
titleOPEN



<text:sheet-name> 7.3.11 Office-3698

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Clarifies the definition of <text:sheet-name> without changing the meaning.

Attributes - New

TopicDeveloperStatusBZ ID / Git commitComment

chart:data-label-series 20.9 Office-2117, Office-3956


Status
colourRed
titleOPEN



chart:regression-force-intercept 20.44 Office-3958


Status
colourRed
titleOPEN



chart:regression-intercept-value 20.45 Office-3958


Status
colourRed
titleOPEN



chart:regression-max-degree 20.46 Office-3958


Status
colourRed
titleOPEN



chart:regression-moving-type 20.47 Office-3959


Status
colourRed
titleOPEN



chart:regression-name 20.48 Office-3958


Status
colourRed
titleOPEN



chart:regression-period 20.49 Office-3959


Status
colourRed
titleOPEN



number:exponent-interval 19.347 Office-1828


Status
colourRed
titleOPEN



number:forced-exponent-sign 19.349 Office-3860


Status
colourRed
titleOPEN



number:max-denominator-value 19.352 of <number:fraction> 16.29.7 Office-3695


Status
colourRed
titleOPEN



number:min-decimal-places 19.356 of <number:number> 19.343.2 ,
<number:scientific-number> 19.356.3, Office-3860


Status
colourRed
titleOPEN



style:contextual-spacing 20.255 Office-3767


Status
colourRed
titleOPEN



style:scale-to-X 20.354 Office-3857


Status
colourRed
titleOPEN



style:scale-to-Y 20.355 Office-3857


Status
colourRed
titleOPEN



table:tab-color 19.731 of <style:table-properties> 17.15 Office-2173


Status
colourRed
titleOPEN



text:current-selected 19.790 Office-3881


Status
colourRed
titleOPEN



...

TopicDeveloperStatusBZ ID / Git commitComment

chart:interpolation 20.27 Office-3692


Status
colourRed
titleOPEN



chart:regression-type 20.50 Office-3958, Office-3959


Status
colourRed
titleOPEN



dr3d:transform 19.107 Office-3848


Status
colourRed
titleOPEN



draw:color-inversion 20.110 Office-3827


Status
colourRed
titleOPEN



draw:concave 19.123 Office-3849


Status
colourRed
titleOPEN



draw:corners 19.128 Office-3849


Status
colourRed
titleOPEN



draw:enhanced-path 19.145 Office-3711


Status
colourRed
titleOPEN



draw:formula 19.171 Office-3822

Damjan Jovanovic 

Status
colourRedGreen
titleOPENCLOSED


Changes atan2(x, y) to atan2(y, x). We already use atan2(y, x).

draw:formula 19.171draw:formula 19.171 Office-3823

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


ODF 1.3 uses radians instead of degrees for trigonometric functions, unlike ODF 1.2. The issue documents how we use radians, and it was changed because no implementations used degrees.

draw:formula 19.171 Office-3826


Status
colourRed
titleOPEN



draw:formula 19.171 Office-3778


Status
colourRed
titleOPEN



draw:gradient-step-count 20.137 Office-3934


Status
colourRed
titleOPEN



draw:handle-position 19.179 Office-3778


Status
colourRed
titleOPEN



draw:mime-type 19.191 Office-3943


Status
colourRed
titleOPEN



draw:sharpness 19.211 Office-3849


Status
colourRed
titleOPEN



draw:style 19.218.5 of <draw:stroke-dash> 16.42.9 Office-3742


Status
colourRed
titleOPEN



draw:style 19.218.2 of <draw:gradient> 16.42.1 Office-3718


Status
colourRed
titleOPEN



draw:style 19.219.27 of <style:master-page> 16.9 Office-3937


Status
colourRed
titleOPEN



draw:transform 19.228 Office-3755

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


ODF 1.2 wrongly said skewX and skewY skew by rotate-angle instead of skew-angle. Such a mistake makes no sense as rotate-angle is undefined, and wouldn't have been implemented that way.
draw:z-index 19.231 Office-2122

Status
colourRed
titleOPEN



fo:background-color 20.182 Office-3927


Status
colourRed
titleOPEN



fo:keep-with-next 20.201 Office-3924


Status
colourRed
titleOPEN



fo:min-height 19.240 of <draw:text-box> 10.4.3 Office-3735


Status
colourRed
titleOPEN



fo:text-align 20.223.1 of <style:paragraph-properties> 17.6 Office-3820


Status
colourRed
titleOPEN



number:grouping 19.350 Office-3888


Status
colourRed
titleOPEN



number:style 19.362.9 of <number:seconds> 16.29.22 Office-3752


Status
colourRed
titleOPEN



office:value-type 19.389 Office-3555


Status
colourRed
titleOPEN



presentation:display-date-time 20.233 Office-3931


Status
colourRed
titleOPEN



presentation:display-page-number 20.236 Office-3931


Status
colourRed
titleOPEN



presentation:source 19.420 Office-4013


Status
colourRed
titleOPEN



smil:accelerate 19.436 Office-3726


Status
colourRed
titleOPEN



smil:accumulate 19.437 Office-3725


Status
colourRed
titleOPEN



smil:additive 19.438 Office-3725


Status
colourRed
titleOPEN



smil:attributeName 19.439 Office-2523


Status
colourRed
titleOPEN



style:class 19.470 Office-3863

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Changes the description of <style:class> without changing the meaning.

style:condition 19.472 of <style-map> 16.3 Office-3882


Status
colourRed
titleOPEN



style:page-number 20.328 of <style:paragraph-properties> 17.6 and
<style:table-properties> 17.15 Office-3923


Status
colourRed
titleOPEN



style:run-through 20.351 Office-2122


Status
colourRed
titleOPEN



style:scale-to 20.352 Office-3857


Status
colourRed
titleOPEN



style:scale-to-pages 20.353 Office-3857


Status
colourRed
titleOPEN



style:text-line-through-text 20.374 Office-3722


Status
colourRed
titleOPEN



style:text-line-through-text 20.374 Office-3723


Status
colourRed
titleOPEN



svg:height 19.543.2 of <chart:legend> 11.4 Office-3883


Status
colourRed
titleOPEN



svg:height 19.543.5 of <dr3d:scene> 10.5.2 Office-3932


Status
colourRed
titleOPEN



svg:stroke-linecap 20.171 Office-3742


Status
colourRed
titleOPEN



svg:viewBox 19.574 Office-3996

Damjan Jovanovic 

Status
colourRedGreen
titleOPENCLOSED


The svg:viewBox coordinates should be interpreted the same as SVG syntax, which is "left top width height", but ODF 1.2 incorrectly said "left top right bottom". In our code, we already use "left top width height".

svg:width 19.575.4 of <chart:legend> 11.4 Office-3883


Status
colourRed
titleOPEN



svg:width 19.575.7 of <dr3d:scene> 10.5.2 Office-3932


Status
colourRed
titleOPEN



svg:x 19.577.5 of <dr3d:scene> 10.5.2 Office-3932


Status
colourRed
titleOPEN



svg:y 19.581.5 of <dr3d:scene> 10.5.2 Office-3932


Status
colourRed
titleOPEN



table:name 19.677.11 of <table:operation> 9.3.3 Office-3728


Status
colourRed
titleOPEN



table:condition 19.600 of <table:content-validation> 9.4.5 Office-3882


Status
colourRed
titleOPEN



table:display 19.621 Office-3754


Status
colourRed
titleOPEN



table:display 19.621 Office-4019


Status
colourRed
titleOPEN



table:end-cell-address 19.631 of <dr3d:scene> 10.5.2,
<draw:caption> 10.3.11, <draw:circle> 10.3.8, <draw:connector> 10.3.10,
<draw:control> 10.3.13, <draw:custom-shape> 10.6.1, <draw:ellipse> 10.3.9,
<draw:frame> 10.4.2, <draw:g> 10.3.15, <draw:line> 10.3.3,
<draw:measure> 10.3.12, <draw:page-thumbnail> 10.3.14, <draw:path> 10.3.7,
<draw:polygon> 10.3.5, <draw:polyline> 10.3.4, <draw:rect> 10.3.2,
<draw:regular-polygon> 10.3.6 and <office:annotation> 14.1. Office-2697


Status
colourRed
titleOPEN



table:expression 19.639 of <table:named-expression> 9.4.13 Office-3882


Status
colourRed
titleOPEN



table:number-rows-spanned 19.682 of <table:table-cell> 9.1.4 Office-3876


Status
colourRed
titleOPEN



table:orientation 19.690.2 of <table:data-pilot-field> 9.6.7 Office-3729


Status
colourRed
titleOPEN



table:style-name 19.730.2 of <table:background> 16.22 Office-3925


Status
colourRed
titleOPEN



table:table-background 19.733 Office-3954

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


This is just a typo. It doesn't change anything semantically.

text:anchor-type 19.759 Office-3945


Status
colourRed
titleOPEN



text:anchor-type 20.418 Office-3945


Status
colourRed
titleOPEN



text:display 19.802.3 of <text:expression> 7.4.14 Office-3929


Status
colourRed
titleOPEN



text:list-id 19.835 Office-1437


Status
colourRed
titleOPEN



text:relative-tab-stop-position 19.861 Office-3946


Status
colourRed
titleOPEN



text:start-value 19.874.6 of <text:numbered-paragraph> 5.3.6 Office-1437


Status
colourRed
titleOPEN



text:style-name 19.880.18 of <text:index-source-style> 8.11 Office-3675


Status
colourRed
titleOPEN



text:style-name 19.880.25 of <text:numbered-paragraph> 5.3.6 Office-1437


Status
colourRed
titleOPEN



text:name 19.841 Office-3881


Status
colourRed
titleOPEN



text:value 19.906 Office-3881


Status
colourRed
titleOPEN



text:track-changes 19.889 Office-3763


Status
colourRed
titleOPEN



...

OPEN
TopicDeveloperStatusBZ ID / Git commitComment

Basic Expressions 5.2 Office-3667


Status
colourRed
titleOPEN


Part of the basic expression BNF changed from:

  FunctionName Whitespace* '(' ParameterList ')' |

to:

  FunctionName '(' ParameterList ')' |

so whitespace is no longer valid between FunctionName and its bracketed parameter list.

Criterion 4.11.8 Office-3766

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes some references within the specification, but no change in meaning.

Criterion 4.11.8 Office-3766

Status
colourRed
title

Sequences 4.11.12 Office-4003

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Changes "shall" to "must" in row/column processing order. It's just a change in the language. If we processed sequences correctly for ODF 1.2, then we should be processing them correctly in ODF 1.3 too.

Functions - Changed

TopicDeveloperStatusBZ ID / Git commitComment

BESSELI 6.16.12 Office-3842

Damjan Jovanovic 

Status
colourRedGreen
titleOPENCLOSED


Changes the type of first argument from Integer to Number. We already use Number.

BESSELJ 6.16.BESSELJ 6.16.13 Office-3842

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Changes the type of first argument from Integer to Number. We already use Number.

BESSELK 6.16.14 Office-3842

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Changes the type of first argument from Integer to Number. We already use Number.

BESSELY 6.16.15 Office-3842

Damjan Jovanovic 

Status
colourRedGreen
titleOPEN

CELL 6.13.3 Office-3909

Status
colourRed
titleOPEN

COVAR 6.18.18 Office-3757

Status
colourRed
titleOPEN

CRITBINOM 6.18.19 Office-3921

Status
colourRed
titleOPEN

CLOSED


Changes the type of first argument from Integer to Number. We already use Number.

CELL 6.13.3 Office-3909

Damjan Jovanovic DAYS360 6.10.7 Office-3907

Status
colourRedGreen
titleOPEN

DCOUNT 6.9.3 Office-3906

Status
colourRed
titleOPEN

DCOUNTA 6.9.4 Office-3906

Status
colourRed
titleOPEN

FLOOR 6.17.3 Office-3879

Status
colourRed
titleOPEN

FTEST 6.18.30 Office-3903

Status
colourRed
titleOPEN

HLOOKUP 6.14.5 Office-3902

CLOSED


Changes the condition under which CELL("ADDRESS", ref) returns the sheet name, from "if given in the reference" to "if given in the reference and does not reference the same sheet as the sheet the expression is evaluated upon". Our CELL function already returns the sheet name under the new condition.

COVAR 6.18.18 Office-3757

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Fixes the formula for covariance, adding the 1/N factor that was missing. We already use it.

CRITBINOM 6.18.19 Office-3921

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Requires that 0 <= Alpha <= 1 instead of the wrong Alpha >= 1 in ODF 1.2. We already require that in our ScInterpreter::ScCritBinom() function, which does:

        if (n < 0.0 || alpha <= 0.0 || alpha >= 1.0 || p < 0.0 || p > 1.0)

            PushIllegalArgument();

Actually, strictly speaking, we require 0 < Alpha < 1, not 0 <= Alpha <= 1, but that's what Excel requires too, so let's leave it as is. Maybe we should report that issue back to OASIS?

DAYS360 6.10.7 Office-3907

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes parameter 3 (Method) from Integer to Logical. For us, it is already logical, method ScInterpreter::ScGetDiffDate360() does:

sal_Bool bFlag;

if (nParamCount == 3)

    bFlag = GetBool();

else

    bFlag = sal_False;

DCOUNT 6.9.3 Office-3906

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

561c6157b86908803ccecf18699e7b5dfaba10b2The 2nd parameter, DatabaseField, is optional in ODF 1.3.

DCOUNTA 6.9.4 Office-3906

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

561c6157b86908803ccecf18699e7b5dfaba10b2The 2nd parameter, DatabaseField, is optional in ODF 1.3.

FLOOR 6.17.3 Office-3879

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


Changes FLOOR() to round towards zero, like it should, instead of away from zero. We already do that.

FTEST 6.18.30 Office-3903


Status
colourRed
titleOPEN


Need to re-examine implementation.

HLOOKUP 6.14.5 Office-3902

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

07b7105f20776a1b6f4e27351365759551337431Changes parameter type to "ForceArray Reference|Array".

IF 6.15.4 Office-3844


Status
colourRed
titleOPEN


Needs to be able to handle missing "then" and "else" expressions, eg. IF(condition;), IF(condition;;) and IF(condition;IfTrue;) all give errors in AOO, but they shouldn't.

ISBLANK 6.13.14 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISFORMULA 6.13.18 Office-4000

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISLOGICAL 6.13.19 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISNONTEXT 6.13.21 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISNUMBER 6.13.22 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISREF 6.13.24 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

ISTEXT 6.13.25 Office-4000

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

LINEST 6.18.41 Office-3902, Office-3948

Status
colourRed
titleOPEN

IF 6.15.4 Office-3844

Status
colourRed
titleOPEN

ISBLANK 6.13.14 Office-4000

Status
colourRed
titleOPEN

ISFORMULA 6.13.18 Office-4000

Status
colourRed
titleOPEN

ISLOGICAL 6.13.19 Office-4000

Status
colourRed
titleOPEN

ISNONTEXT 6.13.21 Office-4000

Status
colourRed
titleOPEN

ISNUMBER 6.13.22 Office-4000

Status
colourRed
titleOPEN

ISREF 6.13.24 Office-4000

Status
colourRed
titleOPEN

ISTEXT 6.13.25 Office-4000


Status
colourRed
titleOPEN

07b7105f20776a1b6f4e27351365759551337431For Office-3902, changes parameter type to "ForceArray".

LOGEST LINEST 6.18.4142 Office-3902, Office-3948

Damjan Jovanovic 

Status
colourRedGreen
titleOPENCLOSED

07b7105f20776a1b6f4e27351365759551337431Changes parameter type to "ForceArray".

MATCH 6.14.9LOGEST 6.18.42 Office-3902

Damjan Jovanovic 

Status
colourRed
titleOPEN
Green
titleCLOSED

07b7105f20776a1b6f4e27351365759551337431Changes parameter type to "ForceArray Reference|Array".

RECEIVED 6.12.43 Office-3916

Damjan Jovanovic MATCH 6.14.9 Office-3902

Status
colourRedGreen
titleCLOSEDOPEN

e172229456487b113132e6d03d331cba42792c7fA new constraint, Settlement < Maturity, had to be implemented on our RECEIVED function.

STDEVP 6.18.74 Office-3856

Damjan Jovanovic RECEIVED 6.12.43 Office-3916

Status
colourRedGreen
titleOPEN

STDEVP 6.18.74 Office-3856

Status
colourRed
titleOPEN

CLOSED


Adds a constraint that mandates a sample size of at least 1 element, which we already require.

STDEVPA 6.18.75 Office-3856

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Adds a constraint that mandates a sample size of at least 1 element, which we already require.

TYPE 6.13.33 Office-4000

Damjan Jovanovic 

Status
OPEN
colourRedtitleGreen
titleCLOSED

118236Updates documentation, adding "This function does not propagate Error values." We already do that.

VARPA 6.18.85 Office-3856

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Adds a constraint that mandates a sample size of at least 1 element, which we already require.

VLOOKUP 6.14.12 Office-3902

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED

07b7105f20776a1b6f4e27351365759551337431Changes parameter type to "ForceArray Reference|Array".

WEEKDAY 6.10.20 Office-3908

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED

b19cfbb97e8a126fb5034f0ea11b69365cb8e0aeAdded support for weekday types 11-17.