[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[libreoffice-users] Behavior that seems ... inconsistant.
- Subject: [libreoffice-users] Behavior that seems ... inconsistant.
- From: Michael Tiernan <email@example.com>
- Date: Mon, 8 Jun 2020 09:00:31 -0400
- To: firstname.lastname@example.org
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: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
- Prev by Date: [libreoffice-users] Style-dependent variables?
- Next by Date: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161
- Previous by thread: [libreoffice-users] Style-dependent variables?
- Next by thread: [libreoffice-users] Printing 18 labels per sheet on Avery A4 sheet L7161