[opensuse] Libre office calc insists on capitalizing some cell contents.
![](https://seccdn.libravatar.org/avatar/77cb4da5f72bc176182dcc33f03a18f3.jpg?s=120&d=mm&r=g)
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, In Spanish the month names are written without capitalization, like "agosto" for the English "August". However, when in a LibreOffice cell I type "agosto" it is automatically replaced with "Agosto". Undo doesn't undo the capitalization. I edit it back, and it is undone. I go to autocorrect, and I add an exception: Replace With Agosto agosto Useless. In options, I untick "Capitalize first letter of every sentence". Useless. I disable "Use replacement table". Useless. What else is left? Where else does it get the order to replace what *I* write with something else? I create a new sheet. I start in a column writing: agosto enero Agosto agosto <--- here it corrects me to Agosto. It refuses to accept lowercase, till I copy paste the first cell into the 4th. agosto on subsequent cells, it forces using the same case as the previous one. Why? Now it insists on using "agosto". Where can I disable that silly, stupid behaviour? ME mandates what to write in MY documents! :-/ In order to correct this, I now have to open a second document, there in a new sheet write the text in the format I want, and copy the cell back to the intended place in the first document. This is stupid! - -- Cheers Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar) -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (GNU/Linux) iEYEARECAAYFAlQx7LIACgkQtTMYHG2NR9XFtgCeMTCjEgX5g6MmKzsYr+Wc607m oEcAniB29TZm/yixTZCKOFpu/ymQZUnx =abKL -----END PGP SIGNATURE----- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/c0deb892c8d6a59d3eb4b475c3d9c9dc.jpg?s=120&d=mm&r=g)
On Sun, Oct 5, 2014 at 7:13 PM, Carlos E. R.
In Spanish the month names are written without capitalization, like "agosto" for the English "August".
However, when in a LibreOffice cell I type "agosto" it is automatically replaced with "Agosto". Undo doesn't undo the capitalization. I edit it back, and it is undone.
It is not happening on my end. I don't even get the correction in English, because the month name is not in my replacement list for "English (USA)" and I do not have a replacement list for "English (Canada)". Can you find it in the replacement list for the language set in the cell for your case? Carlos FL -- Carlos F Lange Gaúcho nas Pradarias http://goo.gl/fvVhr -- Recursive: Adj. See Recursive. -- -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/e164891e4d850a5cfd6a5765eb3965d0.jpg?s=120&d=mm&r=g)
On Sun, Oct 5, 2014 at 7:13 PM, Carlos E. R.
wrote: In Spanish the month names are written without capitalization, like "agosto" for the English "August".
However, when in a LibreOffice cell I type "agosto" it is automatically replaced with "Agosto". Undo doesn't undo the capitalization. I edit it back, and it is undone. ...............
- here : if one adds an extra Space at start of line, then lower-case succeeds regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/b4047644c59f2d63b88e9464c02743fd.jpg?s=120&d=mm&r=g)
Ah, I have seen that problem before.
Did this spreadsheet come from something else, like windows or something?
I found the same thing and found that there was some problem in the conversion and the field delimiters are messed up.
I re_imported it using some different forms of delimiters and it was ok. I don't remember the details unfortunately.
I also seen to recall I was able backspace in each field and clear them one by one but gave up on that method.
On October 10, 2014 12:10:49 AM PDT, ellanios82
On Sun, Oct 5, 2014 at 7:13 PM, Carlos E. R.
wrote: In Spanish the month names are written without capitalization, like "agosto" for the English "August".
However, when in a LibreOffice cell I type "agosto" it is automatically replaced with "Agosto". Undo doesn't undo the capitalization. I edit it back, and it is undone. ...............
- here : if one adds an extra Space at start of line, then lower-case succeeds
regards
-- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
-- Sent from my Android phone with K-9 Mail. Please excuse my brevity. -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/77cb4da5f72bc176182dcc33f03a18f3.jpg?s=120&d=mm&r=g)
On 2014-10-10 10:01, John Andersen wrote:
Ah, I have seen that problem before.
Did this spreadsheet come from something else, like windows or something?
Nope. It was previously OpenOffice, but always in Linux. I had this problem before, but then "undo" would undo the automatic capitalization, or whatever other automatic change, and revert it to what I actually typed. It does not happen now. I don't know when this stopped working. -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
![](https://seccdn.libravatar.org/avatar/77cb4da5f72bc176182dcc33f03a18f3.jpg?s=120&d=mm&r=g)
On 2014-10-10 09:10, ellanios82 wrote:
On Sun, Oct 5, 2014 at 7:13 PM, Carlos E. R <> wrote:
In Spanish the month names are written without capitalization, like "agosto" for the English "August".
However, when in a LibreOffice cell I type "agosto" it is automatically replaced with "Agosto". Undo doesn't undo the capitalization. I edit it back, and it is undone. ...............
- here : if one adds an extra Space at start of line, then lower-case succeeds
Yes, same here. But then add more cells with the same text, with the same space, and try change the capitalization. It is not taking it's cue from the replacement list, but from previous cells in the same column. It is another feature, to make all cells with the /same/ text consistent. -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
![](https://seccdn.libravatar.org/avatar/e164891e4d850a5cfd6a5765eb3965d0.jpg?s=120&d=mm&r=g)
On 10/10/2014 12:49 PM, Carlos E. R. wrote:
- here : if one adds an extra Space at start of line, then lower-case succeeds Yes, same here.
.................... - long-ages ago, was it WordStar, released 1978, for CP/M & DOS, that needed am apostrophe " ' " as prefix, in order to produce a lower-case word-start/line-start letter? .................. regards -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org
![](https://seccdn.libravatar.org/avatar/77cb4da5f72bc176182dcc33f03a18f3.jpg?s=120&d=mm&r=g)
On 2014-10-10 12:42, ellanios82 wrote:
On 10/10/2014 12:49 PM, Carlos E. R. wrote:
- here : if one adds an extra Space at start of line, then lower-case succeeds Yes, same here.
....................
- long-ages ago, was it WordStar, released 1978, for CP/M & DOS, that needed am apostrophe " ' " as prefix, in order to produce a lower-case word-start/line-start letter?
No, I don't think I saw auto correction then. I have my doubts about it having an (Spanish) dictionary. -- Cheers / Saludos, Carlos E. R. (from 13.1 x86_64 "Bottle" at Telcontar)
participants (4)
-
Carlos E. R.
-
Carlos F. Lange
-
ellanios82
-
John Andersen