Issue 35820

Summary: Concatenate fails with long concatenation
Product: Calc Reporter: fitirocz <dpechace>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: OOo 1.1.3   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Bugdoc none

Description fitirocz 2004-10-19 19:20:10 UTC 
This is under Windows XP Pro SP2 and OOo1.1.3

Steps:
1) in cell A1, enter "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
2) in cell A2, enter formula =CONCATENATE(A1;A1..................A1)
with the last A1 in the concatenation being the 170th iteration.
3) hit enter

No value or error is displayed in the cell.  Even if you enlarge 
the cell it still does not show anything.

We also did this by concatenating a large text file with a small
string and got the same result.
Comment 1 frank 2004-11-06 20:39:32 UTC 
Hi Niklas,

please see attached document and follow the description in it.

Frank
Comment 2 frank 2004-11-06 20:40:47 UTC 
Created attachment 19012 [details]
Bugdoc
Comment 3 cs230039 2005-01-26 23:02:27 UTC 
Hi,

My Software Configuration : Windows XP  SP2, running OpenOffice 1.1.3
My Hardware Configuration : Mobile AMD Atholon 1.20Ghz, 256MB RAM

Confirmed the bug. 

The file provided worked correctly. It displayed the concatenated string 
properly.

Test 1 : On adding more A1's in the concatenate formula
Result : The cell does not display anything. Went blank

Test 2 : Increased the concatenated string by adding more A1's (about 100) in 
Concatenate formula.
Result: Returned an error CODE 512, which is the following 

Formula overflow
Compiler: the total number of internal tokens, (that is, operators, variables, 
brackets) in the formula exceeds 512. Interpreter: the total number of 
matrices that the formula creates exceeds 150. This includes basic functions 
that receive too large an array as a parameter (max. 0xFFFE, for example, 
65534 bytes).

Test 3 : To find the break-even point before the cell information goes blank.
Result : The cell can take a maximum of 144 A1's and 15 extra characters for a 
total of 3759 characters. Adding one more character, makes the cell go blank.

Conclusion : I guess there is a peak value set to each cell for the number of 
characters that can be displayed.

Satish_Kumar (cs230039)
Comment 4 elewis 2005-11-01 03:52:04 UTC 
This problem occurs under Linux (Fedora Core 3), MS 2000 (Service Patch 4) and
MS XP all with Open Office Org 2.0 database. Concatenation (in SQL Commanding)
fails whenever there is a list of three or more strings to be concatenated. For
example: concat('String 1 ','String 2') will work, however concat ('String
1','String 2','String 3') will not work. It makes no difference if it is text
strings, or string variables being concatenated - the result is the same. The
length of the string also appears to make no difference.
Comment 5 Marcus 2017-05-20 11:13:39 UTC 
Reset assigne to the default "issues@openoffice.apache.org".