Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 01 Sep 2016 14:37:40 +0200[Calc] Error with Concatenate formulahttps://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/I start to typing the formula:
=conc
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
concatenate()
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"`Thu, 01 Sep 2016 11:07:37 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/Comment by Kruno for <p>I start to typing the formula:</p>
<pre><code>=conc
</code></pre>
<p>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</p>
<pre><code>concatenate()
</code></pre>
<p>with cursor blinking between brackets ...
Other formulas seems to work properly. Got this error</p>
<p>I'm using polish edition and this function is called <code>"=złącz.tekst"</code></p>
https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76364#post-id-76364Can you try to concatenate using formula wizard?Thu, 01 Sep 2016 11:23:00 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76364#post-id-76364Comment by Bri for <p>I start to typing the formula:</p>
<pre><code>=conc
</code></pre>
<p>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</p>
<pre><code>concatenate()
</code></pre>
<p>with cursor blinking between brackets ...
Other formulas seems to work properly. Got this error</p>
<p>I'm using polish edition and this function is called <code>"=złącz.tekst"</code></p>
https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76366#post-id-76366Wizard 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 ?Thu, 01 Sep 2016 11:43:09 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76366#post-id-76366Comment by Bri for <p>I start to typing the formula:</p>
<pre><code>=conc
</code></pre>
<p>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</p>
<pre><code>concatenate()
</code></pre>
<p>with cursor blinking between brackets ...
Other formulas seems to work properly. Got this error</p>
<p>I'm using polish edition and this function is called <code>"=złącz.tekst"</code></p>
https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76376#post-id-76376thanks erAck - altought non-intuitive (should be tab or arrow up/down, enter to accept)Thu, 01 Sep 2016 14:35:26 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76376#post-id-76376Comment by erAck for <p>I start to typing the formula:</p>
<pre><code>=conc
</code></pre>
<p>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</p>
<pre><code>concatenate()
</code></pre>
<p>with cursor blinking between brackets ...
Other formulas seems to work properly. Got this error</p>
<p>I'm using polish edition and this function is called <code>"=złącz.tekst"</code></p>
https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76370#post-id-76370Ctrl+Tab forward, Shift+Ctrl+Tab backward.Thu, 01 Sep 2016 12:14:45 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76370#post-id-76370Answer by erAck for <p>I start to typing the formula:</p>
<pre><code>=conc
</code></pre>
<p>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</p>
<pre><code>concatenate()
</code></pre>
<p>with cursor blinking between brackets ...
Other formulas seems to work properly. Got this error</p>
<p>I'm using polish edition and this function is called <code>"=złącz.tekst"</code></p>
https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?answer=76369#post-id-76369Which 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](https://bugs.documentfoundation.org/).
Thu, 01 Sep 2016 12:12:40 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?answer=76369#post-id-76369Comment by Bri for <p>Which release version are you using anyway? 5.1 or 5.2? Or something older?</p>
<p>Does that happen also with other function names? I suspect this might be related to the <code>ł</code> and <code>ą</code> 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 <a href="https://bugs.documentfoundation.org/">our bug tracker</a>.</p>
https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76377#post-id-76377Little mistake in version numbering
I used previously 5.0.4 and jump already to 5.2.0.4 got problems with 5.1 family (not with 5.3 ;) )Thu, 01 Sep 2016 14:37:40 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76377#post-id-76377Comment by Bri for <p>Which release version are you using anyway? 5.1 or 5.2? Or something older?</p>
<p>Does that happen also with other function names? I suspect this might be related to the <code>ł</code> and <code>ą</code> 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 <a href="https://bugs.documentfoundation.org/">our bug tracker</a>.</p>
https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76375#post-id-76375Currently I'm using 5.2.0.4.
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
=jeżeli.błąd
also deleting equal sign ... ;)
Doesn't happen with
=CZ.CAŁK.DZIELENIA()
(quotient if i recognize right)Thu, 01 Sep 2016 14:34:24 +0200https://ask.libreoffice.org/en/question/76361/calc-error-with-concatenate-formula/?comment=76375#post-id-76375