[Libreoffice-bugs] [Bug 109412] New: FORMATTING - Column Insert does not always insert a New column

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=109412

            Bug ID: 109412
           Summary: FORMATTING - Column Insert does not always insert a
                    New column
           Product: LibreOffice
           Version: 4.4.7.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sgrekow at yahoo.com

Created attachment 134886
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134886&action=edit
Sample - Directions in text

This actually applies to both rows AND columns but will only discuss columns
here.

When inserting a column it is usally a copy of the column to the left of the
insert.  It should remove all information before the actual insert but it
doesn't.

Attached sample has two sheets.  Demo:

1.  Sheet1 has background colors in cells A1:A5 and AMJ1:AMJ10.  Select Column
A & insert column to LEFT.  Cells A1:A10 & B1:B5 now have background colors AND
AMJ column is blank.  If an 'undo' is now selected, A1:A5 has background colors
and column AMJ is blank.

2.  Again starting with original Sheet1, it has background colors in cells
A1:A5 and AMJ1:AMJ10.  Delete column C.  Now the background colors are in cells
A1:A5 and AMI1:AMI10 with a completely blank column AMJ!  AN 'undo' now has
background colors in AMJ1:AMJ10.

3.  Using Sheet2, inserting columns left or right on columns B or C will also
duplicate background colors depending upon which column and direction is
chosen.

This is just an easy to visualize sample.  I came upon this problem because in
an extension I have (Hatch Cells), I store information in
"UserDefinedAttributes".  This causes problems when inserting new columns/rows
because this information is checked to re-generate skewed patterns.  This
information is never cleared for the inserted column.  There could very well be
more fields which retain information upon an insert beside the two mentioned
here.

In the #2 demo above it appears a NEW column is actually appended to the end of
the columns.  If so, why couldn't this be done in other inserts?

The other question arises as to why a new column is allowed in the #1 demo
above since cells in columns A & AMJ (full Sheet) contain information?  If
there was data instead of this other information, the insert wouldn't be
allowed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170727/05df35af/attachment.html>