https://bugs.freedesktop.org/show_bug.cgi?id=81803
Priority: medium
Bug ID: 81803
Assignee: [email protected]
Summary: EDITING: Cell content deleted when fill handle is used
to fill formula in upward-wise direction
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA PossibleRegression
Status: UNCONFIRMED
Version: 4.3.0.3 rc
Component: Spreadsheet
Product: LibreOffice
Problem description:
LO Version: 4.3.0.3 RC3
Build ID: fcd3838c4097f7817b5b3984fd88a44e1edd8548
OS X 10.9.4
Filling cells *with formula* using fill handle works OK ritht, left and
downward direction, but DELETES CELL CONTENT if used to fill cells upward.
Steps to reproduce:
1. Create new spreadsheet
2. Type any text in a cell and use the fill handle to copy: works OK in all
directions (right, left, up and down)
3. Go to another cell and type a formula, e.g., RANDBETWEEN(1;10)
4. Use fill handle to copy the formula down: works OK
5. Use fill handle to copy the formula right: works OK
6. Use fill handle to copy the formula left: works OK
8. Use fill handle to copy the formula up *JUST ONE CELL*: works OK
9. Use fill handle to copy the formula up *two or more cells": NOTHING IS
COPIED (cell contents are empty), and the previous content is erased.
10. Step 9 happens weather you select only one or more cells to use with the
fill handle.
RELATED BEHAVIOUR
I have tested steps 9 and 10 with various formulas and the result is the same:
cell contents are emptied-erased
Steps 9 and 10 are OK if I use automatic filling with a natural number serie:
1,2,3... (I suspect that filling with a serie is not considered *a formula* in
this context)
Current behavior:
The fill handle does not copy *formula* cell content upwards-wise
Expected behavior:
The formula should have been copied using the fill handle
Operating System: Mac OS X
Version: 4.3.0.3 rc
Last worked in: 4.2.5.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs