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
colourGreen
titleCLOSED


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 Document 2.2.5 Office-3746

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


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-2580


Status
colourRed
titleOPEN



Styles General 3.15.1 Office-36973697

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED


Just a change to a cross-reference.

White Space Characters 6.1.2 Office-2102


Status
colourRed
titleOPEN



White Space Processing and EOL Handling 3.18 Office-2102

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
colourGreen
titleCLOSED


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

draw: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
colourGreen
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
colourGreen
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
colourGreen
titleCLOSED


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



...

TopicDeveloperStatusBZ ID / Git commitComment

BESSELI 6.16.12 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


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

BESSELJ 6.16.13 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


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

BESSELK 6.16.14 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


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

BESSELY 6.16.15 Office-3842

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


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

CELL 6.13.3 Office-3909

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


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
OPEN
colourRedGreen
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

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

LOGEST 6.18.42 Office-3902

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED

07b7105f20776a1b6f4e27351365759551337431Changes parameter type to "ForceArray".

MATCH 6.14.9 Office-3902

Damjan Jovanovic 

Status
OPEN
colourRedGreen
titleCLOSED

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

RECEIVED 6.12.43 Office-3916

Damjan Jovanovic 

Status
colourGreen
titleCLOSED

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

STDEVP 6.18.74 Office-3856

Damjan Jovanovic 

Status
colourGreen
titleCLOSED


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
colourGreen
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
colourGreen
titleCLOSED

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

VARPA 6.18.85 Office-3856

Damjan Jovanovic 

Status
colourGreen
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
colourGreen
titleCLOSED

b19cfbb97e8a126fb5034f0ea11b69365cb8e0aeAdded support for weekday types 11-17.

...