History log of /trunk/main/filter/source/xslt/import/spreadsheetml/spreadsheetml2ooo.xsl (Results 1 - 10 of 10)
Revision (<<< Hide revision tags) (Show revision tags >>>) Date Author Comments
# 99ad85ff 11-Jun-2024 John Bampton

Fix spelling (#218)

* Fix spelling

* Update spreadsheetml2ooo.xsl

---------

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


Revision tags: AOO420-Dev5-m5, AOO4115-GA, AOO4114-GA
# 195282cf 14-Jan-2023 Damjan Jovanovic

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


# 0db4a4f4 13-Jan-2023 Damjan Jovanovic

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


# a896732b 12-Jan-2023 Damjan Jovanovic

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


# 577fe179 11-Jan-2023 Damjan Jovanovic

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


Revision tags: AOO420-Dev4-m4, AOO4113-GA, AOO4112-GA, AOO4111-GA, AOO420-Dev3-m3, AOO4110-GA, AOO419-GA, AOO418-GA, 420-Dev2-m2, AOO417, AOO420-Dev-m1, AOO416, AOO416-RC1, AOO415, AOO414, AOO413, AOO4121, AOO412, SNAPSHOT, AOO411
# 07a3d7f1 29-Apr-2014 Pedro Giffuni

Many spelling fixes: directories a* - g*.

Attempt to clean up most but certainly not all the spelling
mistakes that found home in OpenOffice through decades. We
could probably blame

Many spelling fixes: directories a* - g*.

Attempt to clean up most but certainly not all the spelling
mistakes that found home in OpenOffice through decades. We
could probably blame the international nature of the code but
it is somewhat shameful that this wasn't done before.


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

show more ...


Revision tags: AOO410, AOO410_Beta, AOO401, AOO400, AOO340
# 23d132e6 24-Feb-2012 Pedro Giffuni

i77112 - revert for now: It's not clear why the author did not include this in CWS xsltfilter10.

git-svn-id: https://svn.apache.org/repos/asf/incubator/ooo/trunk@1293302 13f79535-47bb-0310-9

i77112 - revert for now: It's not clear why the author did not include this in CWS xsltfilter10.

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

show more ...


# 54b9b0c9 24-Feb-2012 Pedro Giffuni

i77112 - Patch to run Spreadsheetml XSLT import with JDK5/6 and Saxon. Patch by sus.

git-svn-id: https://svn.apache.org/repos/asf/incubator/ooo/trunk@1293286 13f79535-47bb-0310-9956-ffa450ed

i77112 - Patch to run Spreadsheetml XSLT import with JDK5/6 and Saxon. Patch by sus.

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

show more ...


# 1e519d8d 31-Dec-2011 Andrew Rist

Update headers to Alv2 headers

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


# cdf0e10c 16-Aug-2011 rcweir

Initial import of the old OOo hg repository tip revision.

.../trunk/main is a copy of (currently tip-most)
http://hg.services.openoffice.org/OOO340/rev/c904c1944462

.../trunk/

Initial import of the old OOo hg repository tip revision.

.../trunk/main is a copy of (currently tip-most)
http://hg.services.openoffice.org/OOO340/rev/c904c1944462

.../trunk/extras/l10n is a copy of (currently tip-most)
http://hg.services.openoffice.org/master_l10n/OOO340/rev/af6bc9467af5

Note that the following files with line-end and/or encoding anomalies were left out (they will need to be to be checked in separately):

/ooo/trunk/core/dictionaries/de_DE/README_hyph_de_DE.txt
/ooo/trunk/core/dictionaries/de_CH/README_hyph_de_CH.txt
/ooo/trunk/core/dictionaries/de_AT/README_hyph_de_AT.txt
/ooo/trunk/core/gettext/gettext-0.18.1.1.patch
/ooo/trunk/core/apache-commons/patches/codec.patch
/ooo/trunk/core/libcroco/libcroco-0.6.2.patch
/ooo/trunk/core/testautomation/writer/optional/input/import/mactext.txt
/ooo/trunk/core/graphite/graphite-2.3.1.patch
/ooo/trunk/core/hwpfilter/source/hwpeq.cpp
/ooo/trunk/core/solenv/bin/cwstouched.pl
/ooo/trunk/core/readlicense_oo/html/THIRDPARTYLICENSEREADME.html
/ooo/trunk/core/writerfilter/source/doctok/escher.html
/ooo/trunk/core/writerfilter/source/odiapi/qname/resource/office2003/WordprocessingML Schemas/xsdlib.xsd
/ooo/trunk/core/writerfilter/source/odiapi/qname/resource/office2003/WordprocessingML Schemas/wordnetaux.xsd
/ooo/trunk/core/filter/source/xslt/odf2xhtml/export/common/body.xsl
/ooo/trunk/core/filter/source/xslt/odf2xhtml/export/common/styles/style_mapping_css.xsl

Also: Repository.mk from the l10n toplevel


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

show more ...