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: 2025-05-06 03:10 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
Comment 12 QA Administrators 2025-05-06 03:10:39 UTC
Dear Stang,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug