This is being offered as a "data point" to the user interface development.
It may very well be "as expected" but it seemed odd so I thought I'd
mention it to see what other folks thought.
Here's a sequence of operations I'll call "Case 1":
I create a spreadsheet. Column A starts at a number (i.e. 100) and the rest
of the column is "=A1+1" and is filled down using the "Fill Down" menu
option. This gives us 100,101,102, etc. At the bottom of this new column, I
select the bottom entry, do a "Copy" to the clipboard then go down one cell
and "Paste" from the clipboard and the correct value goes in, formatting
So far, nothing unusual.
Now, "Case 2":
I take a second spreadsheet and put my starting number in A1 like before.
BUT, now I go to row 2 and select A2..A4 (three rows) and hit the button to
"Merge and Center Cells" and now I have a big cell in the second position.
I put the same formula in it "=A1+1" and it correctly becomes 101. I select
that cell again and do a "Copy" to the clipboard, go down one cell and am
now on A5. Note, it skipped to the /next/ cell after this enlarged cell. I
"Paste" and it creates a duplicate large cell and puts the adjusted formula
From what I can see, the operations are consistant.
But, now select ths enlarged cell at "A5" (which is A5, A6, A7) and pull
down to A8 and do a "Fill down" and it goes wonky. The cells A6, and A7
suddenly become filled with individual values and the "Merge" done
previously goes away.
It /seems/ (but I might be wrong) that the behavior should have been to
turn A8 and subsequent two more cells into one large cell via an implied
Merge and then copied the contents of the cell above it into it adjusting
the formula appropriately.
Thanks for everyone's time. I hope this is helpful in some way.
Build ID: 3d775be2011f3886db32dfd395a6a6d1ca2630ff
CPU threads: 8; OS: Mac OS X 10.13.6; UI render: default; VCL: osx;
Locale: en-US (en_US.UTF-8); UI-Language: en-US
<< MCT >> Michael C Tiernan. http://www.linkedin.com/in/mtiernan
Non Impediti Ratione Cogatationis
Women and cats will do as they please, and
men and dogs should relax and get used to the idea. -Robert A. Heinlein
To unsubscribe e-mail to: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- [libreoffice-users] Behavior that seems ... inconsistant. · Michael Tiernan
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy