Windows is missing the round() function, try include <math.h>.

Patch by: me

(cherry picked from commit a2fc620dde92e6d35133f9ad89c5bd17ae686d7b)

Add a "Referer" to toolbars

Add a "referer" property to SfxObjectShell::CallXScript() and trust macros explicitly requested by the user

(cherry picked and adapted from commit 9112548547be8d3a47281bcef5925a60e1435527)

Scripts check their "Referer". Menu choices always set a trusted "Referer".

(cherry picked and adapted from commit 98c68b91f53a89d44b8d4d563791eeb186d6d605)

Trust the "Referer" parameter

(cherry picked from commit 8ff7eef7722d15f65826c2c58cd7ce4e768cb9e1)

In ODF (19.679.2 of ODF 1.3), the <table:covered-table-cell> element's
table:number-columns-repeated attribute has a default value of 1,
meaning the cell spans the cell to its right. However

In ODF (19.679.2 of ODF 1.3), the <table:covered-table-cell> element's
table:number-columns-repeated attribute has a default value of 1,
meaning the cell spans the cell to its right. However when the XSLT import
filter converts from SpreadsheetML's ss:MergeAcross to ODF's
table:number-columns-repeated, it always inserts a <table:covered-table-cell>
element, and then adds the table:number-columns-repeated attribute only if
it is greater than 1. This breaks when ss:MergeAcross="0", because ODF's
defaulting to 1 ends up occupying an extra empty cell to the right when it
shouldn't.

Fix this by only inserting the <table:covered-table-cell> when
ss:MergeAcross > 0.

Add a test document to prove this.

Fixes #100989 - SpreadsheetML: cell with ss:MergeAcross="0" gets an extra empty cell to the right
Patch by: me

(cherry picked from commit a896732bfcd282115c06407a2f1da77694fa8d19)

show more ...

When importing SpreadsheetML ss:DateTime, import the entire value, not only the
first 19 characters.

Add a test file for this bug.

Fixes: #128554 - Office 2003 SpreadsheetML: fr

When importing SpreadsheetML ss:DateTime, import the entire value, not only the
first 19 characters.

Add a test file for this bug.

Fixes: #128554 - Office 2003 SpreadsheetML: fractional seconds are silently
ignored during import
Patch by: me

(cherry picked from commit 195282cf3d8bfaa9e1cec43b093251d9df87f4ba)

show more ...

Dates and times are loaded wrongly from SpreadsheetML files, because the filter
loads only the date or time portion of the ss:DateTime based on the cell's
style.

Rather always load t

Dates and times are loaded wrongly from SpreadsheetML files, because the filter
loads only the date or time portion of the ss:DateTime based on the cell's
style.

Rather always load the ss:DateTime as our ODF office:date-value in the
XMLSchema-2 dateTime format, with both its date and time part, and then rely on
formatting to display only the date or time as desired.

Fixes: #82849 - SpreadsheetML ss:DateTime cell value is loaded as either only
a date or a time

Patch by: Philip J. Turmel <philip@turmel.org>
Reviewed by: me

(cherry picked from commit 0db4a4f44da1c0fb06154ba61c960a18427e751b)

show more ...

Our XSLT-based MS Office 2003 SpreadsheetML format import filter, when doing
conversion from R1C1 style column references to our A1 style references, had a
bug where it was treating the colum

Our XSLT-based MS Office 2003 SpreadsheetML format import filter, when doing
conversion from R1C1 style column references to our A1 style references, had a
bug where it was treating the column value as 0-based, and dividing by 26 to
find the 1st letter and taking the remainder when divided by 26 for the second
letter. Those numbers are then each converted to a letter [0 = nothing,
1 = "A", 2 = "B", ..., 26 = "Z"].

However since R1C1 is 1-based, and not 0-based, this breaks for column numbers
which are multiples of 26, as 26 mod 26 = 0, so the least significant digit is
converted to nothing while the most significant digit gets incremented too
early.

Fix this by converting the column number to 0-based by subtracting 1 before
calculation, then adding 1 to the least significant digit afterwards.

Also the fact we have 2 letters limited us to a maximum of 26^2 = 676 columns,
after which column references would wrap around. Fix this too, by adding a 3rd
letter, which lets us address a maximum of 17576 columns.

Add a sample file to our unit tests.

Found by: alex dot plantema at xs4all dot nl
Patch by: me

(cherry picked from commit 577fe17932e0dec38662067d1a86e7fd6ae525b6)

show more ...

Add support for the new XLSX date type in cells, denoted with attribute t="d",
used by Excel 2010.

Also refactor the code so the datetime attribute in pivot tables is also parsed
by

Add support for the new XLSX date type in cells, denoted with attribute t="d",
used by Excel 2010.

Also refactor the code so the datetime attribute in pivot tables is also parsed
by the same function, and increase the parsing accuracy to the maximum (HundredthSeconds,
instead of just Seconds).

Fixes: #127034 - xlsx file: imported DateTime cells are empty (Excel 2010 compatible)
Patch by: me

(cherry picked from commit 9621e552cdf723df9a998b3af4218407d6c66e37)

show more ...

Allow the XLSX Relationship "Target" attribute in _rels/.rels to have superfluous slashes.

Fixes: #117672 - Opening XLSX fails when the Relationship "Target" attribute in _rels/.rels

Allow the XLSX Relationship "Target" attribute in _rels/.rels to have superfluous slashes.

Fixes: #117672 - Opening XLSX fails when the Relationship "Target" attribute in _rels/.rels
has superfluous slashes
Patch by: me

(cherry picked from commit 3ff2b12a82734e8b46c6f7693a7e1b8eef8ada96)

show more ...

Cleaned up resource file for Euro converter

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1847189 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit a2aef65c

Cleaned up resource file for Euro converter

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1847189 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit a2aef65cef30af2a2b86cd1060f20aebbc3f7e58)

show more ...

Cleaning up Euro Converter wizard, moving graphics from bmp to png

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1846157 13f79535-47bb-0310-9956-ffa450edef68
(cherry pick

Cleaning up Euro Converter wizard, moving graphics from bmp to png

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1846157 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit 79ff0626c08e88865fa857521f2748ffc033c5f7)

show more ...

Fixed typo (existant -> existent)

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1810324 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit a1090ed2d1adb3400a

Fixed typo (existant -> existent)

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1810324 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit a1090ed2d1adb3400aefd623934bc30652ff5340)

show more ...

Updated English dictionary

for #i124928, rich text portion could be converted several times, each time when it is converted, the string will be set once, but in the setString logic, the text is inserted instead of set.
Rep

for #i124928, rich text portion could be converted several times, each time when it is converted, the string will be set once, but in the setString logic, the text is inserted instead of set.
Repeated conversion is unnecessary, add a flag to avoid repeated conversion

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1597503 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit c0670b14b16dba0137a280c9aabcadc554988f08)

show more ...

OpenOffice Calc offers functions for converting from old national currencies to EURO.

Croatia joined the euro area in 2023, see:
https://www.ecb.europa.eu/euro/changeover/croatia/html/in

OpenOffice Calc offers functions for converting from old national currencies to EURO.

Croatia joined the euro area in 2023, see:
https://www.ecb.europa.eu/euro/changeover/croatia/html/index.en.html

(cherry picked from commit a658d2c3a558c3c19f1f11cd0c149f02935bb073)

show more ...

OpenOffice Calc offers functions for converting from old national currencies to EURO.

Additional countries joined the euro area: Estonia (2011), Latvia (2014) and Lithuania (2015), see:

OpenOffice Calc offers functions for converting from old national currencies to EURO.

Additional countries joined the euro area: Estonia (2011), Latvia (2014) and Lithuania (2015), see:
https://www.ecb.europa.eu/euro/changeover/estonia/html/index.en.html
https://www.ecb.europa.eu/euro/changeover/latvia/html/index.en.html
https://www.ecb.europa.eu/euro/changeover/lithuania/html/index.en.html

This patch adds those currencies and conversion rates for CONVERT (Calc.xcu) and EUROCONVERT (interpr2.cxx).

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1859148 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit b87f12bb81d7d34bb81a54b5c5528c145f92cca6)

show more ...

Add EURO as default currency in Croatian locale data

(cherry picked from commit 850429207114cd615841eb6e6103f86c37e3e476)

Small change to Euro Converter dialog

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1859223 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit 37dc38adb68c6e

Small change to Euro Converter dialog

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1859223 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit 37dc38adb68c6e301db0393be0f3f19673419557)

show more ...

Corrected StarOffice -> OpenOffice, cleanup

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1846354 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit 48978db4

Corrected StarOffice -> OpenOffice, cleanup

git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1846354 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit 48978db46ebe50f44a403865c2c9de89148f12fc)

show more ...

Small string change in German SDF

Small string changes in Calc (changed cell comment)
This fixes:
https://bz.apache.org/ooo/show_bug.cgi?id=128557

(cherry picked from commit 375f5bafad26878da9deb0e418aea6df7e31d41e)

Show buttons disabled instead of hiding them in Writer
(like we do in Calc)

(cherry picked from commit b993da4edaea17f3980edfac2f17a925d02bd4f0)

Resized dialog, removed unused elements

(cherry picked from commit f4701358be627f6019b7ee44e13b6feb195401d2)