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

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

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


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

WaE: fix implicit conversions from boolean false to the NULL pointer


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

assume STL to always be newer than stlport's version from 2002


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

Revert of r1444110

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

i114430 - AOO Calc: 0^0=1 and it should be indeterminate.

Many spreadsheets and math packages set the value of POWER( 0, 0)
to 1 as that sometimes is required for some calculations. This

i114430 - AOO Calc: 0^0=1 and it should be indeterminate.

Many spreadsheets and math packages set the value of POWER( 0, 0)
to 1 as that sometimes is required for some calculations. This
is also done by the standard C99 libc pow() function.

In mathematical terms the value is an indeterminate form and
in strict mathematical sense such value should at least be
considered with caution.

OpenFormula permits implementation defined values of 0, 1
or error in this case. We shall now return NaN.

Clean some headers while here.


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

show more ...

i121421 - Calc's RAND() behaves poorly on most platforms.

Replace WH2006 PRNG with the well known Mersenne Twister
as implemented in Boost. This actually has some drawbacks
with resp

i121421 - Calc's RAND() behaves poorly on most platforms.

Replace WH2006 PRNG with the well known Mersenne Twister
as implemented in Boost. This actually has some drawbacks
with respect to our previous implementation: we lose the
nifty seeding and instead use the timer which is
non-optimal.

The main reason is the speed: MT is said to be at least
4 times faster.

On the other hand I also moved the WH to the scaddins
module where it is used by Calc's RANDBETWEEN function.
This way we still have the alternative PRNG and we
drop another use of the unreliable rand from libc.


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

show more ...

reverting 1428926 as revison 1428922 does the same and was earlier

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

#i121561# workaround windows build problem with the new boost functions

Stlport 5.2 and newer set the _STLP_HAS_NATIVE_FLOAT_ABS define for all MSVC>=2005,
so that the stl::abs() defines

#i121561# workaround windows build problem with the new boost functions

Stlport 5.2 and newer set the _STLP_HAS_NATIVE_FLOAT_ABS define for all MSVC>=2005,
so that the stl::abs() defines are enabled. Otherwise the compilation fails because
only stl::abs(complex<>) gets included which messes things up because it is the
only one available after the SFINAE eliminations when the compiler tries to
instantiate e.g. boost's atanh using stl::abs()


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

show more ...

i121561 - Use of boost instead of RTL hyperbolic/power functions.

Boost provides some well implemented and tested versions of the
inverse hyperbolic and small power functions. According

i121561 - Use of boost instead of RTL hyperbolic/power functions.

Boost provides some well implemented and tested versions of the
inverse hyperbolic and small power functions. According to the
documentation the error for these boost versions should be about
1 or 2 Epsilon.

Testing shows that for recent Apache OpenOffice this won't cause
much difference but Symphony users will see important precision
improvements.

Special Thanks to Regina Henschel for providing excellent test cases.


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

show more ...

#121463# Enhanced handle visualization and some fixes in that region

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

i121421 - Mostly cosmetic fixes.

Attempt to comply with optional hungarian notation.


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

i121421 - Mostly cosmetic fixes.

Attempt to comply with optional hungarian notation.


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

show more ...

i121421 - Calc's RAND() behaves poorly on most platforms.

The random number generation function from libc was useful for very basic
purposes but hasn't kept up with the times.

T

i121421 - Calc's RAND() behaves poorly on most platforms.

The random number generation function from libc was useful for very basic
purposes but hasn't kept up with the times.

There are many options to provide a Portable Random Number Generator: one
of the most popular and easiest to implement was designed by B.A Wichmann
and I.D Hill in 1982.

We chose to implement the newer 2006[1] algorithm which is better suited
modern platforms and passes DIEHARD and TestU01 - Big Crush tests.

Use of libc's rand() has been completely eliminated by using preexisting
rtl/random support to generate the initial seeds.

Special thanks to orcmid@ for discussion and testing.

Reference:

[1] B. A. Wichmann and Hill, Generating good pseudorandom numbers,
Computational Statistics & Data Analysis, Volume 51 Issue 3,
December, 2006, Pages 1614-1622.


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

show more ...

#i121120 AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

Patch by: Zhang Lu
Review by: Wang Lei

git-svn-id: https://svn.apache.org/repos/a

#i121120 AOO doesn't support RightB(), LeftB(),LenB() and MidB() in formula

Patch by: Zhang Lu
Review by: Wang Lei

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

show more ...

#i121136 Improve Spreadsheet performance in some area (Patch 2)

Patch by: Wang Lei
Review by: Wang Lei

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

#i121136 Improve Spreadsheet performance in some area (Patch 2)

Patch by: Wang Lei
Review by: Wang Lei

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

show more ...

#i121126 User-definded format code is lost with a cell which value is TRUE or FALSE when importing xls file

Patch by: Zhang Lu
Review by: Wang Lei

git-svn-id

#i121126 User-definded format code is lost with a cell which value is TRUE or FALSE when importing xls file

Patch by: Zhang Lu
Review by: Wang Lei

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

show more ...

Reorder initialization to prevent warnings.


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

#i120962 Chart data lost if the source data refers to a range name which is defined as a reference formula

Patch by: Clarence GUO
Review by: Wang Lei

git-svn

#i120962 Chart data lost if the source data refers to a range name which is defined as a reference formula

Patch by: Clarence GUO
Review by: Wang Lei

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

show more ...

calcishmakkica: init vars

From: Eike Rathke <erack@apache.org>

Original Author: Eike Rathke [er] <eike.rathke@oracle.com>
Original Committer: Eike Rathke [er] <eike.rathke@oracl

calcishmakkica: init vars

From: Eike Rathke <erack@apache.org>

Original Author: Eike Rathke [er] <eike.rathke@oracle.com>
Original Committer: Eike Rathke [er] <eike.rathke@oracle.com>

# HG changeset patch
# User Eike Rathke [er] <eike.rathke@oracle.com>
# Date 1298043566 -3600
# Node ID 346e0beefed21519bbb6545bccfea022dd75ed66
# Parent 2416febcae5c81a24b40439f09f91e40a686b911

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

show more ...