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

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

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:

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/trunk@1859148 13f79535-47bb-0310-9956-ffa450edef68
(cherry picked from commit b87f12bb81d7d34bb81a54b5c5528c145f92cca6)

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
(cherry picked from commit faa11fa3567bc0a69178888650acd0c4c28386a8)

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
(cherry picked from commit 2e4d2335e101b0658cddb9e31f2fd229d84bfc1d)

show more ...

OLE update verification. Keep user in-the-know and query them.


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

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

#i123901# formula DGET() gives #VALUE! error when fetching calculation resulting in string
Gets ScDBQueryDataIterator::DataAccessInternal::getCurrent() to handle formulas returning strings.
Note: Tests are only on trunk.
Patch by: damjan.


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

show more ...

#i107619# Merged from r1653973.



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

Bug 124065 - [Performance] Low performance opening attached .ods

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

124033: Made the update of maColManualBreaks more conservative.

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

#i56998# add a space separater between value and unit and remove separator between value and percent to match with ISO 31-0

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

#i56998# add a space separater between value and unit and remove separator between value and percent to match with ISO 31-0

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

show more ...

i123870 corrected import values on xml import with chart, avoid uninitialized values

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

123166: Made the update of maRowManualBreaks more conservative.

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

#i91494# use the same font height for CJK text with Western in drawing object on Calc drawing layer

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

#i91494# use the same font height for CJK text with Western in drawing object on Calc drawing layer

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

show more ...

#i123817# prepare codebase for updating to boost 1.55


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

Bug 123909 - Select one column, paste cell range with merged cell in, AOO will be not responding

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

Bug 123909 - Select one column, paste cell range with merged cell in, AOO will be not responding

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

show more ...

#i123768# [ia2] remove pseudo-automatic noisy comments


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

WaE: reorder initializations to prevent compiler warning.


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

Fix build errors.

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

AOO IA2 enabled draft version 1

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

122927: adjusting change made for 121126 - allow formatting of boolean formula result as number,
but force it, if formatting code contains string/text section

Review by:

122927: adjusting change made for 121126 - allow formatting of boolean formula result as number,
but force it, if formatting code contains string/text section

Review by: Clarence Guo <clarence dot guo dot bj at gmail dot com>



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

show more ...

122862: adjust code for issue 12666 in order to solve regressions 122862, 122870, 122955, 123161 and 123163

For 12666 new internal database ranges have been introduced. The fix reduc

122862: adjust code for issue 12666 in order to solve regressions 122862, 122870, 122955, 123161 and 123163

For 12666 new internal database ranges have been introduced. The fix reduced its usage to the once needed
for the Auto Filter function. Standard Filter and Special Filter should be untouched now.



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

show more ...

#i122827# fix the performance regression in xls saving introduced by #i119707#

by correcting the calculation of the last row with visible attributes

Patch by: Yan Peng Guo
Debug

#i122827# fix the performance regression in xls saving introduced by #i119707#

by correcting the calculation of the last row with visible attributes

Patch by: Yan Peng Guo
Debugged by: Herbert Duerr
Found by: k.wehrlin@hotmail.com


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

show more ...

i121008 corrected calc cell comment stuff

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

i118840 Make it possible to identify temporary calc docs and use it to not access inexistent data

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

i118840 Make it possible to identify temporary calc docs and use it to not access inexistent data

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

show more ...