I can't reproduce this in 5.1.3.2-6.6 on openSUSE.

I have interpreted the instructions as;
enter text "cat" into sheet1.A1
enter "=Sheet1.A1" into sheet2.A1
copy sheet2.A1 (Ctl c)
select sheet2.A1:sheet2.A120
paste (Ctl v)

I have also tried entering "cat" into Sheet1.A1:Sheet1.A120 and dragging sheet2.A1 down so that the references increment (=Sheet1.A1 =Sheet1.A2 =Sheet1.A3 etc.)

Steve

On 2016-06-01 04:48, Rob wrote:
Can’t reproduce this in OSX El Capitan (10.11.4) with LO 5.0.4.2

Rob.

Op 31 mei 2016, om 18:16 heeft Pedro <[email protected]> het volgende 
geschreven:

Hi Thomas


Thomas Boehm wrote
I found an annoying bug (or is it a feature?) in Calc. When I create a
new document in calc and fill column A in Sheet1 with text. Now I add
Sheet2 and put "=Sheet1.A1" in cell A1 of Sheet2. Everything behaves as
expected so far.

If I copy down A1 in Sheet2 up to A99 everything is fine too, but if I
copy it down until A100 or more everything turns UPPERCASE and I cannot
change it.

I'm using LO 5.1.3.2 at the moment, but I observed this behavior in
earlier versions too.

Am I doing something wrong or is this really a bug?
It is indeed a bug!

A very similar problem has been reported
https://bugs.documentfoundation.org/show_bug.cgi?id=99753

Maybe you can open a new bug report with your description? (it doesn't seem
to be exactly the same and developers are very picky)

I can confirm it also occurs in version 5.1.3.2 x64 under Windows 7 Pro x64
(so it's not a Windows

Hope this helps
Pedro



--
View this message in context: 
http://nabble.documentfoundation.org/copying-down-references-to-other-cells-turns-text-to-UPPERCASE-tp4184881p4184887.html
Sent from the Users mailing list archive at Nabble.com.

--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to