Bug 83653 - FILEOPEN - ODS - Formula (REPT) - cell shows no repeated value on German locale Windows
Summary: FILEOPEN - ODS - Formula (REPT) - cell shows no repeated value on German loca...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2014-09-09 09:05 UTC by Svante Schubert
Modified: 2021-06-08 11:50 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Only occures on Windows (8.1 64bit) with German locale (14.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-09-09 09:05 UTC, Svante Schubert

Note You need to log in before you can comment on or make changes to this bug.
Description Svante Schubert 2014-09-09 09:05:34 UTC
Created attachment 105957 [details]
Only occures on Windows (8.1 64bit) with German locale

Loading the test document does not result in rows 1 to 6 and 10th with repeated content, but only a subset.

It does occur on English/Mac, but German/Windows. We assume the locale and formula separation might be involved or the high number of repeated character 32k.

The document is attached.
Comment 1 raal 2014-09-19 13:24:39 UTC
Setting as NEW, because according to help this function should return max. 255 characters (The result can be a maximum of 255 characters.)

Comment 2 QA Administrators 2015-10-14 19:57:28 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2016-11-08 11:23:02 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-12-03 14:20:32 UTC Comment hidden (obsolete)
Comment 5 Andreas Heinisch 2021-06-08 11:50:35 UTC
Should we added the same limitation as Excel[1] and adapt the documentation accordingly, or vice versa? The ods-standard[2] specifies an integer for the count.

[1] https://support.microsoft.com/en-us/office/rept-function-04c4d778-e712-43b4-9c15-d656582bb061
[2] http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018870_715980110