misc: fix spelling (#186)

* misc: fix spelling

* Update cmdid.h

* Update svdopath.cxx

* Update RowSetCache.cxx

---------

Co-authored-by: Matthias

misc: fix spelling (#186)

* misc: fix spelling

* Update cmdid.h

* Update svdopath.cxx

* Update RowSetCache.cxx

---------

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

show more ...

Also allow:
pCBFCP->pClipDoc->GetClipParam().getSourceDocID() == 0
instead of only:
pCBFCP->pClipDoc->GetClipParam().getSourceDocID() == GetDocumentID()
in ScDocument::CopyBlockFromCl

Also allow:
pCBFCP->pClipDoc->GetClipParam().getSourceDocID() == 0
instead of only:
pCBFCP->pClipDoc->GetClipParam().getSourceDocID() == GetDocumentID()
in ScDocument::CopyBlockFromClip(), because that's what it is when
cells are dragged and dropped instead of cut and pasted.

Fixes: #128566 - cell displacement problem
Patch by: me

(cherry picked from commit 3accd9b1ca87d0b4656a691efa455d8f0a24bdc9)

show more ...

Fixed typos, cleanup, use nicer ASCII art

(cherry picked from commit 8394eaf1fad0975eb24ede5398e6e9454648880f)

Merge pull request #164 from DamjanJovanovic/editeng-32bit-paragraphs

Update EditEngine code to use 32 bit paragraph storage

(cherry picked from commit d5edfd09768da46c2f9d7c365bf67

Merge pull request #164 from DamjanJovanovic/editeng-32bit-paragraphs

Update EditEngine code to use 32 bit paragraph storage

(cherry picked from commit d5edfd09768da46c2f9d7c365bf67318f0694735)

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

Fixed typo (arbitray -> arbitrary)

(cherry picked from commit f9f5b5667a1c19794e99a0d701b2253e3c70ba25)

Fixed more typos (catched -> caught), removed whitespace

(cherry picked from commit 2eda3cbf09288370cef8ee33ae6d85a5cf00a3bb)

Fixed minor issues with UI and help

(cherry picked from commit 1673b41ccca2e8351b3f388eb3cad66ccef1c3d1)

Merged r1859148 from trunk:

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

Additional countries joined the euro area: Estonia (2011), Latvia (

Merged r1859148 from trunk:

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/branches/AOO42X@1859149 13f79535-47bb-0310-9956-ffa450edef68

show more ...

Make spreadsheets ask to update links. CVE CVE-2017-3157

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

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

Port main/sc to gbuild.
Also add the ability to add extra image directories to resources,
which is needed by main/sc.

Patch by: me


git-svn-id: https://svn.apache.org/re

Port main/sc to gbuild.
Also add the ability to add extra image directories to resources,
which is needed by main/sc.

Patch by: me


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

show more ...

RAND(): Destroy the random pool after seeding.

We are using rtl_random() only for seeding, we can save some memory here.


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

RAND(): Destroy the random pool after seeding.

We are using rtl_random() only for seeding, we can save some memory here.


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

show more ...

Spelling, spelling ...

Why worry about some sprinkled German when we haven't yet learned English.


git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1745006 13f79535

Spelling, spelling ...

Why worry about some sprinkled German when we haven't yet learned English.


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

show more ...

#i126901# CSV import: values with + or - followed by thousand separator and
3 digits (eg. +,123) are imported as a number

Do not allow numbers parsed from CVS files when "Detect special

#i126901# CSV import: values with + or - followed by thousand separator and
3 digits (eg. +,123) are imported as a number

Do not allow numbers parsed from CVS files when "Detect special numbers" is
off, to contain thousand separators before digits, even if after a +/- sign
(eg. -,123 or +,789). Treat these as strings instead.

Also added unit tests for this and exported the ScStringUtil class so it
can be tested.

Patch by: me



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

show more ...

#i118023# Calc: Cut-and-paste between spreadsheets causes incorrect cell reference changes

When pasting cut cells, Calc updates references to their old positions
to instead refer to thei

#i118023# Calc: Cut-and-paste between spreadsheets causes incorrect cell reference changes

When pasting cut cells, Calc updates references to their old positions
to instead refer to their new positions. This is done using the tab index,
row and column, however the document is not taken into account. As a result,
when cutting and pasting between documents, cells in the target document
end up getting changed instead of in the source, potentially leading to
formula corruption, which is undoable but could easily go unnoticed,
causing data loss when the document is saved.

We don't really support inter-document reference updates anyway, so fix
this bug by restricting reference updates to the intra-document cut and
paste case only.

Patch by: me
Reviewed by: kschenk



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

show more ...

#i126701# Patch for adding bit shift functions to calc

Patch by: Pathangi Janardhanan Jatinshravan <JATINSHR001 at e dot ntu dot edu dot sg>
Review by: me




git-svn

#i126701# Patch for adding bit shift functions to calc

Patch by: Pathangi Janardhanan Jatinshravan <JATINSHR001 at e dot ntu dot edu dot sg>
Review by: me




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

show more ...

#i126668# Addition of Bitwise Arithmetic Operations (BITAND, BITOR and BITXOR) in calc

Patch by: Pathangi Janardhanan Jatinshravan <JATINSHR001 at e dot ntu dot edu dot sg>
Review by: me

#i126668# Addition of Bitwise Arithmetic Operations (BITAND, BITOR and BITXOR) in calc

Patch by: Pathangi Janardhanan Jatinshravan <JATINSHR001 at e dot ntu dot edu dot sg>
Review by: me



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

show more ...

#i60307# search for strings in date formats fails.
When "Search in" is set to "Values", search the formatted values
instead of just the raw input. This fixes a 9 year old
bug that's been

#i60307# search for strings in date formats fails.
When "Search in" is set to "Values", search the formatted values
instead of just the raw input. This fixes a 9 year old
bug that's been duplicated at least 6 times, and matches what Excel
does. Tests show even "Replace" works, and works well: if
"October" is replaced by "November", it converts the original
month from 10 to 11; it only converts the cell type to text if the
resulting text is no longer a valid date. Also added BVT tests
for the expected behaviour.



git-svn-id: https://svn.apache.org/repos/asf/openoffice/trunk@1712367 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 ...

Minor cleanups in the random generator code.

Drop unused variables.
Enhance slightly the naming of static variables.


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

Minor cleanups in the random generator code.

Drop unused variables.
Enhance slightly the naming of static variables.


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

show more ...

Re-implement Calc's RAND() function using a variant of KISS PRNG.

George Marsaglia's KISS algorithm is a rather simple implementation
of a random number generator but it has interesting

Re-implement Calc's RAND() function using a variant of KISS PRNG.

George Marsaglia's KISS algorithm is a rather simple implementation
of a random number generator but it has interesting properties with
respect ot the traditional Mersenne Twister.

I used the 2011 32 bit Multiply-with-carry variant, with an
undetermined period which is known to be not less than 10^40000000;
it is known to pass all the statistical tests.

The Apache OpenOffice implementation uses an aggressive seeding
scheme based on the internal rtl_random functions, rendering the
function basically unpredictable. As a side effect it is also not
possible to specify a seed for repeatability. No claims are made
concerning crypto-safeness.

The specific adaption for Apache OpenOffice is:

Copyright 2015 Pedro Giffuni
All rights reserved.

Huge thanks to Steve Kargl for pointing me to the algorithm and
the late George Marsaglia for creating it in the first place.


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

show more ...

#i107619# update search result while repeating search

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

i124638 Second step of DrawingLayer FillAttributes for Writer objects, now added support for Paragraph and PageStyle (including Header and Footer) for direct attributes and style attributes

i124638 Second step of DrawingLayer FillAttributes for Writer objects, now added support for Paragraph and PageStyle (including Header and Footer) for direct attributes and style attributes

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

show more ...

Many spelling fixes: directories r* - z*.

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 r* - z*.

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@1591062 13f79535-47bb-0310-9956-ffa450edef68

show more ...