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

ReFix for #i119707 Cell border lost when saving and reopening the attached xls file.

Patch by: Zhang Lu
Review by: Wang Lei

git-svn-id: https://svn.apache.or

ReFix for #i119707 Cell border lost when saving and reopening the attached xls file.

Patch by: Zhang Lu
Review by: Wang Lei

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

show more ...

#i121285 calc crashes when inserting row's via macro

Patch by: Clarence GUO
Review by: Wang Lei

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

#i121285 calc crashes when inserting row's via macro

Patch by: Clarence GUO
Review by: Wang Lei

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

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

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 1)

Patch by: Wang Lei
Review by: Wang Lei

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

show more ...

#i119707 Cell border lost when saving and reopening the attached xls file.

Patch by: Zhang Lu
Review by: Wang Lei

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

#i119707 Cell border lost when saving and reopening the attached xls file.

Patch by: Zhang Lu
Review by: Wang Lei

git-svn-id: https://svn.apache.org/repos/asf/incubator/ooo/trunk@1391286 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 initializations to prevent warnings.


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

Reorder initialization to prevent warnings.


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

#i121073 Loading performance for xls file with row banded style is bad

Patch by: Wang Lei
Review by: Wang Lei

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

#i121073 Loading performance for xls file with row banded style is bad

Patch by: Wang Lei
Review by: Wang Lei

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

show more ...

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

#i120575 optimize a comparing operation from 'memcmp' to 'hash compare' to improve xls loading performance

Patch by: li zhang (lizh.fee@gmail.com)
Review by: Wang Lei

#i120575 optimize a comparing operation from 'memcmp' to 'hash compare' to improve xls loading performance

Patch by: li zhang (lizh.fee@gmail.com)
Review by: Wang Lei

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

show more ...

#i120847 Resubmit to take back some codes which is roll back to fix a build break bug 120854

Patch by: Tan Li(litan.test@gmail.com)
Review by: Wang Lei

git-s

#i120847 Resubmit to take back some codes which is roll back to fix a build break bug 120854

Patch by: Tan Li(litan.test@gmail.com)
Review by: Wang Lei

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

show more ...

#i120854 Module sc fails to build

Patch by: Li Tan
Review by: Wang Lei

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

#i120854 Module sc fails to build

Patch by: Li Tan
Review by: Wang Lei

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

show more ...

#i120847 Optimizing algorithm of creating pivot table cache when loading a xls file with pivot table

Patch by: Tan Li(litan.test@gmail.com)
Review by: Wang Lei

#i120847 Optimizing algorithm of creating pivot table cache when loading a xls file with pivot table

Patch by: Tan Li(litan.test@gmail.com)
Review by: Wang Lei

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

calcishmakkica: WaE wntmsci12

From: Eike Rathke <erack@apache.org>

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

calcishmakkica: WaE wntmsci12

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 1297940971 -3600
# Node ID 2416febcae5c81a24b40439f09f91e40a686b911
# Parent 0d84fd3534ea7cda60f795f7dc5d99db58d8cc6e


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

show more ...

calcishmakkica: #i90269# #i95144# #i101466#

From: Eike Rathke <erack@apache.org>

* For SUMIFS, AVERAGEIFS and COUNTIFS:
* All ranges must be of same dimension and size.

calcishmakkica: #i90269# #i95144# #i101466#

From: Eike Rathke <erack@apache.org>

* For SUMIFS, AVERAGEIFS and COUNTIFS:
* All ranges must be of same dimension and size.
* Bail out if error encountered for any parameter, without calculating
remaining parameters.
* Adapted ScParameterClassification to cope with paired repeated parameters.
* In function resource have a trailing blank for repeated parameters so the
number is appended with a blank between.

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 1288820521 -3600
# Node ID 79da8a1033b663c919f0dc48799f70256bffa497
# Parent 02cf226fcde498f6fd926d45df497e9fb412fe0f


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

show more ...

calcishmakkica: #i90269# #i95144# #i101466# implement SUMIFS, AVERAGEIFS, COUNTIFS; patch from <makkica>

From: Eike Rathke <erack@apache.org>

Original Author: Marina Plakalovic <mak

calcishmakkica: #i90269# #i95144# #i101466# implement SUMIFS, AVERAGEIFS, COUNTIFS; patch from <makkica>

From: Eike Rathke <erack@apache.org>

Original Author: Marina Plakalovic <makkica@openoffice.org>
Original Committer: Eike Rathke [er] <eike.rathke@oracle.com>

# HG changeset patch
# User Eike Rathke [er] <eike.rathke@oracle.com>
# Date 1288810126 -3600
# Node ID 02cf226fcde498f6fd926d45df497e9fb412fe0f
# Parent 528da6bfd0daed4355d745590d5ac3a319b08fb4

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

show more ...

calcishmakkica: #i114428# implement XOR

From: Eike Rathke <erack@apache.org>

Original Author: Marina Plakalovic <makkica@openoffice.org>
Original Committer: Eike Rathke [er] <ei

calcishmakkica: #i114428# implement XOR

From: Eike Rathke <erack@apache.org>

Original Author: Marina Plakalovic <makkica@openoffice.org>
Original Committer: Eike Rathke [er] <eike.rathke@oracle.com>

# HG changeset patch
# User Eike Rathke [er] <eike.rathke@oracle.com>
# Date 1284060031 -7200
# Node ID 528da6bfd0daed4355d745590d5ac3a319b08fb4
# Parent 237cb91dd986ff11eb100cc631206cda102e91f7


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

show more ...

calcishmakkica: #i101466# implement AVERAGEIF; slightly reworked patch by <makkica>

From: Eike Rathke <erack@apache.org>

Original Author: Marina Plakalovic <makkica@openoffice.org>

calcishmakkica: #i101466# implement AVERAGEIF; slightly reworked patch by <makkica>

From: Eike Rathke <erack@apache.org>

Original Author: Marina Plakalovic <makkica@openoffice.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 1284055400 -7200
# Node ID 237cb91dd986ff11eb100cc631206cda102e91f7
# Parent 1c32319bb02fdf173de6a609fca9f2e9c9f4c73a

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

show more ...

#i120478 Enhancement request: support sheet scoped named ranges in Calc

Patch by: zhaoshzh (Zhao Shao Zhi)
Review by: Wang Lei

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

#i120478 Enhancement request: support sheet scoped named ranges in Calc

Patch by: zhaoshzh (Zhao Shao Zhi)
Review by: Wang Lei

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

show more ...

Fix i12666 autofilter works just on one sheet (only one auto-range per document)

Patch by: zhanglu.aoo
Submit by: Wang Lei



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

Fix i12666 autofilter works just on one sheet (only one auto-range per document)

Patch by: zhanglu.aoo
Submit by: Wang Lei



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

show more ...

#120515# Implemented and finetuned the enhanced Undo feature (see #120498#) for sc

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

#120515# Implemented and finetuned the enhanced Undo feature (see #120498#) for sc

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

show more ...