misc: fix spelling (#188)

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>

show more ...

misc: fix spelling (#185)

I think we are OK!

misc: fix spelling (#184)

misc: fix spelling (#183)

* misc: fix spelling

* Update svdedxv.cxx

Small additions

---------

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

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

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

Refs #128536 - fixes BasicSheetTest.insertSheetFromfile locks up and times out (#158)

fix: set broken UNO BasicSheetTest to ignore and added two new mixed UNO/VCL test classes with three tes

Refs #128536 - fixes BasicSheetTest.insertSheetFromfile locks up and times out (#158)

fix: set broken UNO BasicSheetTest to ignore and added two new mixed UNO/VCL test classes with three tests each to cover ignored tests for Excel and now also Calc sources.

Refs: #128536

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

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.

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

show more ...

Fixed typos, removed whitespace, removed multiple license headers

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

show more ...

Typo.

Patch by: me

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

Patch by: me

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

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

show more ...

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

Patch by: me

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

Patch by: me

RotateAngle is a java.lang.Long

Patch by: me

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