Issue 35820 - Concatenate fails with long concatenation
Summary: Concatenate fails with long concatenation
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOo 1.1.3
Hardware: PC Windows XP
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-10-19 19:20 UTC by fitirocz
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Bugdoc (5.72 KB, application/octet-stream)
2004-11-06 20:40 UTC, frank 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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".