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)
Version:
(earliest affected)
4.3.1.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
 
Reported: 2014-09-09 09:05 UTC by Svante Schubert
Modified: 2023-06-09 03:35 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
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
Details

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

https://help.libreoffice.org/Calc/Text_Functions#REPT
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
Comment 6 QA Administrators 2023-06-09 03:14:35 UTC Comment hidden (obsolete)
Comment 7 ady 2023-06-09 03:35:52 UTC
(In reply to raal from comment #1)
> Setting as NEW, because according to help this function should return max.
> 255 characters (The result can be a maximum of 255 characters.)
> 
> https://help.libreoffice.org/Calc/Text_Functions#REPT

(In reply to Andreas Heinisch from comment #5)
> 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

FWIW, as of LO 7.6, the limit for REPT()'s second argument is ((2^28)-1).

Example: =REPT("i";(2^28)-1) will/should work, whereas =REPT("i";(2^28)) will/should result in Err:513.

ATM, this is documented correctly.

Whether there is still a problem for the original reporter, IDK.