Bug 109529 - FORMATTING - Column inserts even with information in A1 & AMJ1
Summary: FORMATTING - Column inserts even with information in A1 & AMJ1
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.7.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Sheet
  Show dependency treegraph
 
Reported: 2017-07-27 20:59 UTC by Stang
Modified: 2023-05-06 14:01 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Insert column sample (7.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-07-27 20:59 UTC, Stang
Details
excel's warning message (10.72 KB, image/png)
2017-07-28 14:42 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Stang 2017-07-27 20:59:42 UTC
Created attachment 134912 [details]
Insert column sample

Attached sample has two sheets.  Demo:

  Sheet1 has background colors in cells A1:A5 and AMJ1:AMJ10.  Select any Column  & insert column.  AMJ column is now blank.  If an 'undo' is now selected column AMJ remains blank.

It is not just background colors.  Have experienced this with data in "UserDefinedAttributes".

A new column should not be allow to be inserted.
Comment 1 Xisco Faulí 2017-07-27 22:52:27 UTC
Thank you for reporting the bug.
it seems you're using an old version of LibreOffice.
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 2 Stang 2017-07-27 23:07:05 UTC
The stated version was for EARLIEST AFFECTED.  That is the oldest I have.

This was tested in and is present in:

    v4.4.7.2
    v5.0.6.3
    v5.1.1.3
    v5.2.0.4
    v5.3.4.2

AND  tested with 

    master-2017-07-20_2.42.49_LibreOfficeDev_6.0.0.0.alpha
Comment 3 raal 2017-07-28 14:42:25 UTC
Created attachment 134943 [details]
excel's warning message
Comment 4 raal 2017-07-28 14:42:40 UTC
Confirming
Comment 5 Stang 2017-12-23 23:48:24 UTC
This bug is still present in Beta of:

Version: 6.0.0.1
Build ID: d2bec56d7865f05a1003dc88449f2b0fdd85309a
CPU threads: 4; OS: Linux 4.8; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 6 QA Administrators 2018-12-24 03:44:17 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2020-12-24 03:52:30 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2022-12-25 03:21:35 UTC Comment hidden (obsolete)
Comment 9 BogdanB 2023-05-06 11:57:10 UTC
Column is now just moved to the right, and with undo everything is like before.
Can you test again?
Comment 10 ady 2023-05-06 13:23:10 UTC
(In reply to BogdanB from comment #9)
> Column is now just moved to the right, and with undo everything is like
> before.
> Can you test again?

That's not accurate. Column AMJ is by now not the last column.

Testing the behavior with the last possible column still shows the same problem.
Comment 11 BogdanB 2023-05-06 13:49:39 UTC
(In reply to ady from comment #10)
> (In reply to BogdanB from comment #9)
> > Column is now just moved to the right, and with undo everything is like
> > before.
> > Can you test again?
> 
> That's not accurate. Column AMJ is by now not the last column.
> 
> Testing the behavior with the last possible column still shows the same
> problem.

Ok, I didn't know it was the last column, now the last one is XFD.
With XFD marked, I confirm the bug. If the last columns have data, no column should be inserted and maybe a warning should be shown.

Aslo in
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0f2581204a70038ed7ca78089a9bd96d158e02c0
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded