[Issue 127800] New: Line(s) disappear using sheet.removeRange()

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127800

          Issue ID: 127800
        Issue Type: DEFECT
           Summary: Line(s) disappear using sheet.removeRange()
           Product: Calc
           Version: 4.1.5
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: programming
          Assignee: issues@openoffice.apache.org
          Reporter: spam@win-hand.com
  Target Milestone: ---

Created attachment 86436
  --> https://bz.apache.org/ooo/attachment.cgi?id=86436&action=edit
Click on the "Delete Draft" purple button

When using the VBA function

I spent the time required to create a quality
OO file reproducing the problem extremely clearly.
See attached file:
    "Bug DestroyRow Line format.ods"

Open the file, allow scripts
(look at the code, it is super simple, a few lines only).

Click the button  "Delete Draft".

Expected result:
- The orange line "Draft" should be deleted and
the remaining lines below should move up and maintain their
formatting EXACTLY like if you would delete the draft line manually.

Actual result:
- The Draft line is deleted BUT the formatting of the height of the lines below
is not moved up with the lines leaving some line to disappear.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127800] Line(s) disappear using sheet.removeRange()

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127800

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127800] Line(s) disappear using sheet.removeRange()

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127800

oooforum (fr) <oo...@free.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_OOO_ISSUE
                 CC|                            |oooforum@free.fr

--- Comment #1 from oooforum (fr) <oo...@free.fr> ---
If you want delete entire rows, use the right parameter:
com.sun.star.sheet.CellDeleteMode.ROWS

See :
https://www.openoffice.org/api/docs/common/ref/com/sun/star/sheet/CellDeleteMode.html

-- 
You are receiving this mail because:
You are the assignee for the issue.