UnoApp.close() was issuing XDesktop.terminate(), and then starting a timer
that would kill OpenOffice 2 second seconds, while also killing it in the
finally block, and not waiting for it to e

UnoApp.close() was issuing XDesktop.terminate(), and then starting a timer
that would kill OpenOffice 2 second seconds, while also killing it in the
finally block, and not waiting for it to exit. This sometimes caused tests
to start OpenOffice before the previous instance fully finished,
especially in the fvt.uno.sc.formula.TestFormulaDocs test which starts up
OpenOffice for each document, and then the new instance wouldn't start,
causing test failures.

Rather, after issuing XDesktop.terminate(), wait up to 5 seconds for
OpenOffice to exit. Only if it's still running, kill it. This is similar
to what VclApp already does.

Patch by: me

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

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

show more ...

Use our own round() function declared in rtl's math.hxx, instead of the system
round() function only available in C99 compilers.

Patch by: me

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

Patch by: me

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

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

show more ...

Remove Bitmaps from build (#163)

* Remove Bitmaps from build

* Remove directory

* Remove directory from packaging

* Cleanup

* Further cleanup

Change the tip for the Label control in Basic IDE.

This fixes https://bz.apache.org/ooo/show_bug.cgi?id=128553

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

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

show more ...

When rows and cells lack the "r" attribute used to specify their location,
use the location of the most recently added row or cell + 1.

Fixes: #127672 - Xlsx with omitted cell references

When rows and cells lack the "r" attribute used to specify their location,
use the location of the most recently added row or cell + 1.

Fixes: #127672 - Xlsx with omitted cell references opens with empty cells
Patch by: me

show more ...

Some 3rd party applications write OOXML files whose ZIP entries have filenames in
different casing than their XML files specify, eg. sharedStrings.xml is actually
stored in the ZIP file as Sh

Some 3rd party applications write OOXML files whose ZIP entries have filenames in
different casing than their XML files specify, eg. sharedStrings.xml is actually
stored in the ZIP file as SharedStrings.xml. Thus, when we can't find files with
their intended casing, do a case-insensitive search within their ZIP directory
instead.

Fixes: https://bz.apache.org/ooo/show_bug.cgi?id=126720 - no text imported from xlsx
Patch by: me

show more ...

Unifying layout templates (en-US/en_GB) for Impress

(cherry picked from commit efa4771fb6e052730b3cc1d462802a9ee0ebbc85)

Localized Polish layout templates for Impress.

Contributed by Czesław Wolański.

Updated translation.

Contributed by Czesław Wolański.

Unifying dimensions and names for StartCenter graphics

Add the "&apos;" entity definition to our HTML parser, so that we can correctly
read it and convert it a "'", but when writing to HTML write out the "'"
directly for now.

Fixes: http

Add the "&apos;" entity definition to our HTML parser, so that we can correctly
read it and convert it a "'", but when writing to HTML write out the "'"
directly for now.

Fixes: https://bz.apache.org/ooo/show_bug.cgi?id=80657

Patch by: me

show more ...

Align graphics in StartCenter

Updated English dictionary

Updated Ukrainian dictionary

Update copyright year to 2023

When we reach EOF, and SvStream.ReadCsvLine() returned some data,
process that data before returning.

Fixes https://bz.apache.org/ooo/show_bug.cgi?id=128548 -
"Last CSV line is silen

When we reach EOF, and SvStream.ReadCsvLine() returned some data,
process that data before returning.

Fixes https://bz.apache.org/ooo/show_bug.cgi?id=128548 -
"Last CSV line is silently lost on import if last field is quoted
and EOF is reached before closing quote"

Patch by: me

show more ...

Cleanup resource file, removed Maskcolor

Fixed typos, removed whitespace