Versions Compared

Key

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

...

The following items are a list of all changes in ODF 1.3

...

.

Table of Contents
minLevel2

List

...

of all changes in ODF 1.3

...

part 2

(Source: OASIS - Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 3: OpenDocument Schema - Appendix G - Changes From ODF 1.2 (Non Normative))

Table of Contents
minLevel2

New and changed descriptions, elements, attributes and values

...

: https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part2-packages/OpenDocument-v1.3-os-part2-packages.html)

Sections - New

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

Interactions Between Encryption and Digital Signatures 3.9 Office-3869


Status
colourRed
titleOPEN



manifest:checksum-type 4.16.3 Office-3940


Status
colourRed
titleOPEN

...



Sections - Changed

TopicDeveloperStatusBZ ID / Git commitComment
Change Tracking General 5.5.1
Normative references 1.3 Office-
38737
3866

Status
colourRed
titleOPEN

Document Fields – General


Normative References 1.3
.1
 Office-
3783
3867

Status
colourRed
titleOPEN

Drawing Page Style 16.41


Normative References 1.3 Office-
3937
3868

Status
colourRed
titleOPEN

Foreign elements and attributes 3.17


Namespaces 1.5 Office-
3950 , Office-4034
4002

Status
colourRed
titleOPEN

List Item Style Rules 5.3.5


OpenDocument Package 2.2.1 Office-
3782
3858

Status
colourRed
titleOPEN

Normative References 1.3 Office-3868



Elements - New

TopicDeveloperStatusBZ ID / Git commitComment

<manifest:encrypted-key> 4.8 Office-3940


Status
colourRed
titleOPEN

Open Document Drawing Document 2.2.5


<manifest:encryption-method> 4.9 Office-

3744

3940


Status
colourRed
titleOPEN

Open Document Drawing Document 2.2.5


<manifest:keyinfo> 4.10 Office-

3746

3940


Status
colourRed
titleOPEN

OpenDocument Text Document 2.2.3


<manifest:PGPData> 4.11 Office-

2580

3940


Status
colourRed
titleOPEN

Styles General 3.15.1


<manifest:PGPKeyID> 4.12 Office-3940


Status
colourRed
titleOPEN



<manifest:PGPKeyPacket> 4.13 Office-

3697

3940


Status
colourRed
titleOPEN

White Space Characters 6.1.2


<manifest:CipherData> 4.14 Office-

2102

3940


Status
colourRed
titleOPEN

White Space Processing and EOL Handling 3.18


<manifest:CipherValue> 4.15 Office-

2102

3940


Status
colourRed
titleOPEN

...



Attributes - New

TopicDeveloperStatusBZ ID / Git commitComment
<chart:coordinate-region> 11.3

manifest:PGPAlgorithm 4.17 Office-

3928

3940


Status
colourRed
titleOPEN

<meta:creator-initials> 14.4



Descriptions - Changed

TopicDeveloperStatusBZ ID / Git commitComment

<dsig:document-signatures> 5.2 Office-

3776

3869


Status
colourRed
titleOPEN

<number:fill-character> 16.29.5


<ds:signature> 5.3 Office-

3765

3870


Status
colourRed
titleOPEN

<style:footer-first> 16.13


<ds:signature> 5.3 Office-

3789

3871


Status
colourRed
titleOPEN

<style:header-first> 16.11


<manifest:algorithm> 4.5 Office-

3789

3859


Status
colourRed
titleOPEN

<text:drop-down> 7


Encryption-General 3.4.

16

1 Office-

3881

3875


Status
colourRed
titleOPEN



List of all changes in ODF 1.3 part 3

(Source: OASIS - Open Document Format for Office Applications (OpenDocument) Version 1.3. Part 3: OpenDocument Schema - Appendix G - Changes From ODF 1.2 (Non Normative))

Descriptions - New

<text:label> 7.4.17 Office-3881 Statuscolour
TopicDeveloperStatusBZ ID / Git commitComment
Change Tracking General 5.5.1 Office-3873

Status
colour

Red
titleOPEN

...



Description - Changed

TopicDeveloperStatusBZ ID / Git commitComment
<chart:legend> 11.4
Change Tracking General 5.5.1 Office-
3883
3873

Status
colourRed
titleOPEN

<config:config-item-set> 3.10.2


Document Fields – General 7.3.1 Office-

3684

3783

Status
colour

Red

Green
title

OPEN<draw:applet> 10.4.7

CLOSED


Just a typo.

Drawing Page Style 16.41 Office-

2044

3937


Status
colourRed
titleOPEN

<draw:fill-image> 16.42.6 Office-3933


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


Status
colourRed
titleOPEN

<draw:image> 10.4.4


List Item Style Rules 5.3.5 Office-

3922

3782


Status
colourRed
titleOPEN

<dr3d:scene> 10.5.2


Normative References 1.3 Office-

3932

3868


Status
colourRed
titleOPEN

<number:date-style> 16.29.11


Open Document Drawing Document 2.2.5 Office-

1832

3744

Damjan Jovanovic 

Status
colour

Red

Green
title

OPEN

<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

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

Damjan Jovanovic 

Status
colour

Red

Green
title

OPEN<number:scientific-number> 16.29.6 Office-3860

CLOSED


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

<office:automatic-styles>


Styles General 3.15.

3

1 Office-

3683

3697

Damjan Jovanovic 

Status
colour

Red

Green
title

OPEN<style:default-page-layout> 16.8

CLOSED


Just a change to a cross-reference.

White Space Characters 6.1.2 Office-

3696

2102


Status
colourRed
titleOPEN

<style:drawing-page-properties> 17.25


White Space Processing and EOL Handling 3.18 Office-
3937
2102

Status
colourRed
titleOPEN

<style:master-page> 16.9 Office-3679

Status
colourRed
titleOPEN

<style:style> 16.2 Office-3935


Elements - New

TopicDeveloperStatusBZ ID / Git commitComment

<chart:coordinate-region> 11.3 Office-3928


Status
colourRed
titleOPEN

<style


<meta:

tab

creator-

stops>17

initials>14.

7

4 Office-

3845

3776


Status
colourRed
titleOPEN

<style


<number:

text

fill-

properties>

character>16.29.

29

5 Office-

3895

3765


Status
colourRed
titleOPEN

<table


<style:

covered-table-cells> 9.1.5

footer-first> 16.13 Office-

3877

3789


Status
colourRed
titleOPEN

<table


<style:

source-cell-range> 9.6.5

header-first> 16.11 Office-

3665

3789


Status
colourRed
titleOPEN

<table


<text:

table

drop-

columns>9

down>7.

1

4.

12

16 Office-

3839

3881


Status
colourRed
titleOPEN

<table:table-rows> 9.1.8


<text:label> 7.4.17 Office-
3838
3881

Status
colourRed
titleOPEN



Elements - Changed

TopicDeveloperStatusBZ ID / Git commitComment

<chart:legend> 11.4 Office-3883

<text:numbered-paragraph> 5.3.6 Office-1437

Status
colourRed
titleOPEN

<text:sheet-name> 7.3.11 Office-3698TopicDeveloperStatusBZ ID / Git commitCommentchart:data-label-series 20.9 Office-2117, Office-3956


Status
colourRed
titleOPEN

Attributes - New



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


Status
colourRed
titleOPEN

chart:regression-force-intercept 20.44


<draw:applet> 10.4.7 Office-

3958

2044

Damjan Jovanovic 

Status
colour

Red

Green
title

OPEN

CLOSED

chart:regression-intercept-value 20.45

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

<draw:fill-image> 16.42.6 Office-

3958

3933


Status
colourRed
titleOPEN

chart:regression-max-degree 20.46


<draw:image> 10.4.4 Office-

3958

3922


Status
colourRed
titleOPEN

chart:regression-moving-type 20.47


<dr3d:scene> 10.5.2 Office-

3959

3932


Status
colourRed
titleOPEN

chart


<number:

regression-name 20.48

date-style> 16.29.11 Office-

3958

1832


Status
colourRed
titleOPEN

chart


<number:

regression-period 20.49

fill-character> 16.29.1 Office-

3959

3765


Status
colourRed
titleOPEN

number:exponent-interval 19.347


<number:fraction> 16.29.7 Office-

1828

3695


Status
colourRed
titleOPEN

number:forced-exponent-sign 19.349


<number:number> 16.29.3 Office-3860


Status
colourRed
titleOPEN

number


<number:

max-denominator-value 19.352 of <number:fraction>

scientific-number>16.29.

7

6 Office-

3695

3860


Status
colourRed
titleOPEN

number


<office:

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

automatic-styles> 3.15.3 Office-3683


Status
colourRed
titleOPEN

style


<style:

contextual-spacing 20.255

default-page-layout> 16.8 Office-

3767

3696


Status
colourRed
titleOPEN

style


<style:

scale

drawing-

to

page-

X20

properties>17.

354

25 Office-

3857

3937


Status
colourRed
titleOPEN

style


<style:

scale-to-Y 20.355

master-page> 16.9 Office-

3857

3679


Status
colourRed
titleOPEN

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


<style:style> 16.2 Office-

2173

3935


Status
colourRed
titleOPEN

text


<style:

current

tab-

selected 19

stops>17.

790

7 Office-

3881TopicDeveloperStatusBZ ID / Git commitCommentchart:interpolation 20.27 Office-3692

3845


Status
colourRed
titleOPEN

Attributes - Changed



<style:text-properties> 16.29.29 Office-3895


Status
colourRed
titleOPEN

chart


<table:

regression-type 20.50 Office-3958, Office-3959

covered-table-cells> 9.1.5 Office-3877


Status
colourRed
titleOPEN

dr3d:transform 19.107


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

3848

3665


Status
colourRed
titleOPEN

draw


<table:

color-inversion 20.110

table-columns> 9.1.12 Office-

3827

3839


Status
colourRed
titleOPEN

draw:concave 19.123


<table:table-rows> 9.1.8 Office-

3849

3838


Status
colourRed
titleOPEN

draw:corners 19.128


<text:numbered-paragraph> 5.3.6 Office-

3849

1437


Status
colourRed
titleOPEN

draw


<text:

enhanced-path 19.145

sheet-name> 7.3.11 Office-

3711

3698

Damjan Jovanovic 

Status
colour

Red

Green
title

OPEN

draw:formula 19.171 Office-3822

Status
colourRed
titleOPEN

draw:formula 19.171 Office-3823

CLOSED


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

draw:formula 19.171


chart:regression-force-intercept 20.44 Office-

3826

3958


Status
colourRed
titleOPEN

draw:formula 19.171


chart:regression-intercept-value 20.45 Office-

3778

3958


Status
colourRed
titleOPEN

draw


chart:

gradient

regression-

step

max-

count

degree20.

137

46 Office-

3934

3958


Status
colourRed
titleOPEN

draw


chart:

handle-position 19.179

regression-moving-type 20.47 Office-

3778

3959


Status
colourRed
titleOPEN

draw


chart:

mime

regression-

type19

name20.

191

48 Office-

3943

3958


Status
colourRed
titleOPEN

draw:sharpness 19.211


chart:regression-period 20.49 Office-

3849

3959


Status
colourRed
titleOPEN

draw


number:

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

exponent-interval 19.347 Office-1828


Status
colourRed
titleOPEN



number:forced-exponent-sign 19.349 Office-3860


Status
colourRed
titleOPEN

draw:style


number:max-denominator-value 19.

218.2

352 of

<draw

<number:

gradient>

fraction>16.

42

29.

1

7 Office-

3718

3695


Status
colourRed
titleOPEN

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


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


Status
colourRed
titleOPEN

draw:transform 19.228


style:contextual-spacing 20.255 Office-

3755

3767


Status
colourRed
titleOPEN

draw


style:

z-index 19.231

scale-to-X 20.354 Office-

2122

3857


Status
colourRed
titleOPEN

fo


style:

background

scale-to-

color

Y20.

182

355 Office-

3927

3857


Status
colourRed
titleOPEN

fo


table:

keep-with-next 20.201 Office-3924

Status
colourRed
titleOPEN

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

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


Status
colourRed
titleOPEN

fo:


text

-align 20.223.1 of <style:paragraph-properties> 17.6

:current-selected 19.790 Office-

3820

3881


Status
colourRed
titleOPEN

number:grouping 19.350


Attributes - Changed

TopicDeveloperStatusBZ ID / Git commitComment

chart:interpolation 20.27 Office-

3888

3692


Status
colourRed
titleOPEN

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


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


Status
colourRed
titleOPEN

office


dr3d:

value-type

transform19.

389

107 Office-

3555

3848


Status
colourRed
titleOPEN

presentation


draw:

display

color-

date-time

inversion20.

233

110 Office-

3931

3827


Status
colourRed
titleOPEN

presentation:display-page-number 20.236


draw:concave 19.123 Office-

3931

3849


Status
colourRed
titleOPEN

presentation


draw:

source

corners19.

420

128 Office-

4013

3849


Status
colourRed
titleOPEN

smil


draw:

accelerate

enhanced-path19.

436

145 Office-

3726

3711


Status
colourRed
titleOPEN

smil


draw:

accumulate

formula19.

437

171 Office-

3725

3822

Damjan Jovanovic 

Status
colourRed
titleOPEN

smil:additive 19.438 Office-3725

Status
colour

Red

Green
title

OPEN

smil:attributeName 19.439 Office-2523

Status
colourRed
titleOPEN

style:class 19.470 Office-3863

CLOSED


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

draw:formula 19.171 Office-3823

Damjan Jovanovic 

Status
colour

Red

Green
title

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

CLOSED


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

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


draw:formula 19.171 Office-

3923

3778


Status
colourRed
titleOPEN

style


draw:

run

gradient-step-

through

count20.

351

137 Office-

2122

3934


Status
colourRed
titleOPEN

style


draw:

scale

handle-

to20

position19.

352

179 Office-

3857

3778


Status
colourRed
titleOPEN

style


draw:

scale-to-pages 20.353

mime-type 19.191 Office-

3857

3943


Status
colourRed
titleOPEN

style:text-line-through-text 20.374


draw:sharpness 19.211 Office-

3722

3849


Status
colourRed
titleOPEN



draw:style

:text-line-through-text 20.374

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

3723

3742


Status
colourRed
titleOPEN

svg


draw:

height

style19.

543

218.2 of

<chart:legend> 11.4

<draw:gradient> 16.42.1 Office-

3883

3718


Status
colourRed
titleOPEN

svg


draw:

height

style19.

543

219.

5

27 of

<dr3d:scene> 10.5.2

<style:master-page> 16.9 Office-

3932

3937


Status
colourRed
titleOPEN

svg:stroke-linecap 20.171


draw:transform 19.228 Office-

3742

3755

Damjan Jovanovic 

Status
colour

Red

Green
title

OPENsvg:viewBox 19.574 Office-3996

CLOSED


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

svg:width 19.575.4 of <chart:legend> 11.4


fo:background-color 20.182 Office-

3883

3927


Status
colourRed
titleOPEN

svg:width 19.575.7 of <dr3d:scene> 10.5.2


fo:keep-with-next 20.201 Office-

3932

3924


Status
colourRed
titleOPEN

svg


fo:

x

min-height19.

577.5

240 of

<dr3d

<draw:

scene>

text-box>10.

5

4.

2

3 Office-

3932

3735


Status
colourRed
titleOPEN

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


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


Status
colourRed
titleOPEN

table


number:

name

grouping19.

677.11 of <table:operation> 9.3.3

350 Office-

3728

3888


Status
colourRed
titleOPEN

table


number:

condition

style19.

600

362.9 of

<table:content-validation> 9.4.5

<number:seconds> 16.29.22 Office-

3882

3752


Status
colourRed
titleOPEN

table


office:

display

value-type19.

621

389 Office-

3754

3555


Status
colourRed
titleOPEN

table


presentation:display

19.621

-date-time 20.233 Office-

4019

3931


Status
colourRed
titleOPEN

table


presentation:

end

display-

cell

page-

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

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



Removed descriptions, elements, attributes and values

TopicDeveloperStatusBZ ID / Git commitComment

The deprecated attribute 'office:process-content' (19.377 in ODF 1.2.) has been removed. Office-4034


Status
colourRed
titleOPEN



Deprecated MIME Types

TopicDeveloperStatusBZ ID / Git commitComment

odi Table 25 - Registered MIME types Office-2002


Status
colourRed
titleOPEN



oti Table 25 - Registered MIME types Office-2002


Status
colourRed
titleOPEN



Declared Namespace Change

TopicDeveloperStatusBZ ID / Git commitComment

urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0


Status
colourRed
titleOPEN




List of all changes in ODF 1.3 part 4

(Source: https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#__RefHeading___Toc1134097_2705524876)

Description - Changed

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.

Sequences 4.11.12 Office-4003

Damjan Jovanovic 

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

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

Status
colourRed
titleOPEN

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
07b7105f20776a1b6f4e27351365759551337431For Office-3902, changes parameter type to "ForceArray".

LOGEST 6.18.42 Office-3902

Damjan Jovanovic 

Status
colour

Red

Green
titleCLOSED

OPENtext:style-name 19.880.18 of <text:index-source-style> 8.11 Office-3675
07b7105f20776a1b6f4e27351365759551337431Changes parameter type to "ForceArray".

MATCH 6.14.9 Office-3902

Damjan Jovanovic 

Status
colour

Red

Green
title

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

CLOSED

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

RECEIVED 6.12.43 Office-3916

Damjan Jovanovic 

Status
colour

Red

Green
title

OPENtext:name 19.841 Office-3881

CLOSED

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

STDEVP 6.18.74 Office-3856

Damjan Jovanovic 

Status
colour

Red

Green
title

OPENtext:value 19.906

CLOSED


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

STDEVPA 6.18.75 Office-

3881

Status
colourRed
titleOPEN

text:track-changes 19.889 Office-3763

3856

Damjan Jovanovic 

Status
colour

Red

Green
title

OPEN

Removed descriptions, elements, attributes and values

CLOSED


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 
TopicDeveloperStatusBZ ID / Git commitCommentThe deprecated attribute 'office:process-content' (19.377 in ODF 1.2.) has been removed. Office-4034

Status
colour

Red

Green
title

OPEN

CLOSED

Deprecated MIME Types

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

VARPA 6.18.85 Office-3856

Damjan Jovanovic 
TopicDeveloperStatusBZ ID / Git commitCommentodi Table 25 - Registered MIME types Office-2002

Status
colour

Red

Green
title

OPEN

oti Table 25 - Registered MIME types Office-2002

Status
colourRed
titleOPEN

Declared Namespace Change

CLOSED


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

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

WEEKDAY 6.10.20 Office-3908

Damjan Jovanovic 
TopicDeveloperStatusBZ ID / Git commitCommenturn:oasis:names:tc:opendocument:xmlns:datastyle:1.0

Status
colour

Red

Green
title

OPEN

CLOSED

b19cfbb97e8a126fb5034f0ea11b69365cb8e0aeAdded support for weekday types 11-17.