Ask Your Question

[Calc] Error with Concatenate formula [closed]

asked 2016-09-01 11:07:37 +0200

Bri gravatar image

updated 2020-09-11 13:06:42 +0200

Alex Kemp gravatar image

I start to typing the formula:


in one point calc suggest me proper formula (conacatenate) and then I hit [Enter] to autocomplete. In this moment calc removes equal sign "=" from the beggining of the formula leaving olny plain text in cell


with cursor blinking between brackets ... Other formulas seems to work properly. Got this error

I'm using polish edition and this function is called "=złącz.tekst"

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-11 13:07:05.392822


Can you try to concatenate using formula wizard?

Kruno gravatar imageKruno ( 2016-09-01 11:23:00 +0200 )edit

Wizard works. It's all about manually typed formula.

Got another question - if I type "=C" calc suggest me few formulas starting with this letter - how can i switch between them ?

Bri gravatar imageBri ( 2016-09-01 11:43:09 +0200 )edit

Ctrl+Tab forward, Shift+Ctrl+Tab backward.

erAck gravatar imageerAck ( 2016-09-01 12:14:45 +0200 )edit

thanks erAck - altought non-intuitive (should be tab or arrow up/down, enter to accept)

Bri gravatar imageBri ( 2016-09-01 14:35:26 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2016-09-01 12:12:40 +0200

erAck gravatar image

Which release version are you using anyway? 5.1 or 5.2? Or something older?

Does that happen also with other function names? I suspect this might be related to the ł and ą in the Polish function name and there's a pattern that function names with such character (or the combination) make the completion fail and functions without such character don't, is it? If so then please report a bug in our bug tracker.

edit flag offensive delete link more


Currently I'm using It could probably happen before but i do not bet on that, I did'nt install new releases 'cos 5.3 was non-usable at all (freezes, force closes..).

It could be connected with polish characters 'cos "if error" formula


also deleting equal sign ... ;)

Doesn't happen with


(quotient if i recognize right)

Bri gravatar imageBri ( 2016-09-01 14:34:24 +0200 )edit

Little mistake in version numbering I used previously 5.0.4 and jump already to got problems with 5.1 family (not with 5.3 ;) )

Bri gravatar imageBri ( 2016-09-01 14:37:40 +0200 )edit

Question Tools

1 follower


Asked: 2016-09-01 11:07:37 +0200

Seen: 310 times

Last updated: Sep 01 '16