misc: fix spelling (#188)

(cherry picked from commit 658724749b24075f388495ec64d7dee08bfc1db1)

misc: fix spelling (#187)

* misc: fix spelling

* Update TestExtension.java

* Update FilterFactory.idl

* Update ExtendedTypeDetectionFactory.idl

* Update L

misc: fix spelling (#187)

* misc: fix spelling

* Update TestExtension.java

* Update FilterFactory.idl

* Update ExtendedTypeDetectionFactory.idl

* Update LocationTest.java

* Update HelpComponent.java

* Update HelpSearch.java

* Update TestExtension.java

* Update SOReportJobFactory.java

---------

Co-authored-by: Matthias Seidel <mseidel@apache.org>
(cherry picked from commit 7f5c89d5b2565ed069498a1c8ac682c2e94f3fe2)

show more ...

misc: fix spelling (#185)

I think we are OK!

(cherry picked from commit 07225a5114337e103be90ecef3d7824f6e2778ac)

misc: fix spelling (#184)

(cherry picked from commit 81afc36f7a09c292588450c65ebdfe3d58b4bfc3)

misc: fix spelling (#183)

* misc: fix spelling

* Update svdedxv.cxx

Small additions

---------

Co-authored-by: Matthias Seidel <mseidel@apache.org>
(ch

misc: fix spelling (#183)

* misc: fix spelling

* Update svdedxv.cxx

Small additions

---------

Co-authored-by: Matthias Seidel <mseidel@apache.org>
(cherry picked from commit 06fb39a16a5bf3c389e9853a62dce04a425b8019)

show more ...

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

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

Tab function test document and test (#156)

Refs i19221 - added test and test document to test star basic Tab function in Calc.

Patch-By: Czesław Wolański
(cherry picked from com

Tab function test document and test (#156)

Refs i19221 - added test and test document to test star basic Tab function in Calc.

Patch-By: Czesław Wolański
(cherry picked from commit 3b297b461537a449cdc46a885832873b48e62701)

show more ...

Refs i126272 - add test and test document for testing Basic comment in single-line if statements (#152)

* Refs i126272 - added test and test document to test fix for comment in single line i

Refs i126272 - add test and test document for testing Basic comment in single-line if statements (#152)

* Refs i126272 - added test and test document to test fix for comment in single line if statement.

(cherry picked from commit 07758af81c4094b8c020cf9852c971f9ff19be4f)

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

Fix TestFormulaDocs to run against AOO41X, make parameterized, and fix late screenshots (#149)

updated TestFormulaDocs test to be a parameterized test to better see which document failed.

Fix TestFormulaDocs to run against AOO41X, make parameterized, and fix late screenshots (#149)

updated TestFormulaDocs test to be a parameterized test to better see which document failed.
Fixed late screenshots on failures.
Added timeout for dialog hangs when running tests against AOO41X branch due to some BASIC bug fixes for i112383 [1] and it's commit [2] and i117960 [3] and it's commit [4] not being back-ported to AOO41X.

[1] https://bz.apache.org/ooo/show_bug.cgi?id=112383
[2] 323c350

[3] https://bz.apache.org/ooo/show_bug.cgi?id=117960
[4] 725d867

(cherry picked from commit 7d8592c79cfa104063570593e943fed55296950b)

show more ...

Fixed typos, removed whitespace, removed multiple license headers

(cherry picked from commit 916729d09a13a81b9710827c57afa2a17578286c)

Deal with a test that expects strikeout style (X, /, bold, etc.)
to be preserved when saving to .doc, even though neither
the fileformat, nor apparently MS Office itself, support that.

Deal with a test that expects strikeout style (X, /, bold, etc.)
to be preserved when saving to .doc, even though neither
the fileformat, nor apparently MS Office itself, support that.

Closes i120656 - the bold,with / and with X strike through change to single when save to doc

Patch by: me

(cherry picked from commit 4e588b9e25e0ea797c0e7d78b564a1b48a56819e)

show more ...

Typo.

Patch by: me

(cherry picked from commit ff9157e3c2e6eea1bdfb12a088bffba652a52002)

Allow for tested editing time to be a little longer than expected.

Patch by: me

(cherry picked from commit 13ae91bf77e0f3b925db7293580c0ad450ab5530)

Add the registry modification that will disable clearing user personal
info on saving, so that saving and reloading fields like revision number
can be tested.

Closes #i128398# - auto

Add the registry modification that will disable clearing user personal
info on saving, so that saving and reloading fields like revision number
can be tested.

Closes #i128398# - autotest fvt.uno.sd.file.CheckFileProperties loses some DocumentProperties when saving

Patch by: me

(cherry picked from commit ce8ed6d52e206eeb0bf9eb7547f3b52546514d5e)

show more ...

Test hangs indefinitely on a link update confirmation dialog,
and I couldn't find how to confirm the dialog programmatically,
so at least make it time out instead of hanging
the whole tes

Test hangs indefinitely on a link update confirmation dialog,
and I couldn't find how to confirm the dialog programmatically,
so at least make it time out instead of hanging
the whole test run.

Patch by: me

(cherry picked from commit b554e61d4a216798d7a7b23d9f8fa51b42aef9bb)

show more ...

java.util.Calendar's HOUR is a 12 hour clock, use HOUR_OF_DAY instead.

Patch by: me

(cherry picked from commit 7b7d1fc921ba2302ad7151595f2580263add807a)

java.util.Calendar's MONTH is 0-based.

Patch by: me

(cherry picked from commit d917f5e50e8747870854d4ad71be7f834cc09fd3)

RotateAngle is a java.lang.Long

Patch by: me

(cherry picked from commit 0eabae982571a4b36cda4dad5508e00553ddfa53)

Fix an fvt test that was failing because long and java.lang.Integer
can't be compared.

Patch by: me



git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@18148

Fix an fvt test that was failing because long and java.lang.Integer
can't be compared.

Patch by: me



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

show more ...

#i117960# Basic: Line Input doesn't work in single-line If

i92642 added the ability to use certain keywords as variable names (eg. name = 1, line = "hi"),
but also caused a regression wh

#i117960# Basic: Line Input doesn't work in single-line If

i92642 added the ability to use certain keywords as variable names (eg. name = 1, line = "hi"),
but also caused a regression where "Line Input" is broken in single-line If statements.
This patch fixes that by allowing Then and Else to also be the start-of-line tokens expected to
immediately preceed the "Line" token in order for that "Line" token to be recognized a keyword instead
of a variable name. Also added FVT spreadsheet tests for "Line" as both a variable name and as "Line Input".

Patch by: me



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

show more ...

#i123901# formula DGET() gives #VALUE! error when fetching calculation resulting in string
Gets ScDBQueryDataIterator::DataAccessInternal::getCurrent() to handle formulas returning strings.
A

#i123901# formula DGET() gives #VALUE! error when fetching calculation resulting in string
Gets ScDBQueryDataIterator::DataAccessInternal::getCurrent() to handle formulas returning strings.
Added a spreadsheet test for this behaviour.



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

show more ...

#i112383# CLng("&HFFFFFFFF") fails on 64-bits rather than returning -1

Found-by: andrew
Patch-by: Damjan Jovanovic



git-svn-id: https://svn.apache.org/repos/asf/openoff

#i112383# CLng("&HFFFFFFFF") fails on 64-bits rather than returning -1

Found-by: andrew
Patch-by: Damjan Jovanovic



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

show more ...

#i117989# Basic functions Day(), Hour(), Minute(), and Second() return wrong results for dates <1900-1-1

Also extended our spreadsheeet test to search through more columns, open spreadsheets

#i117989# Basic functions Day(), Hour(), Minute(), and Second() return wrong results for dates <1900-1-1

Also extended our spreadsheeet test to search through more columns, open spreadsheets
with macros enabled, and added a test for the the Year(), Month(), Day(), Hour(),
Minute(), and Second() functions comparing Calc's formulas vs StarBasic's runtime functions.

Found-by: villeroy
Patch-by: Damjan Jovanovic



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

show more ...