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

Reply via email to