Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

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
and all.

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
in it.

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
Calc: threaded

    << MCT >>   Michael C Tiernan.

    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:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.