Bug 62377 - FORMATTING: deleting column breaks conditional formatting
Summary: FORMATTING: deleting column breaks conditional formatting
Status: RESOLVED DUPLICATE of bug 62206
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.1.2 release
Hardware: Other macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: regression
Depends on:
Blocks:
 
Reported: 2013-03-15 16:13 UTC by tony_silva
Modified: 2013-03-25 08:41 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
test spreadsheet for reproducing problem per above (10.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-15 16:13 UTC, tony_silva
Details

Note You need to log in before you can comment on or make changes to this bug.
Description tony_silva 2013-03-15 16:13:29 UTC
Created attachment 76570 [details]
test spreadsheet for reproducing problem per above

Deleting a column breaks the conditional formatting in columns to the
right of the removed column.  The problem appears when running
LibreOffice 4.0.1.2 on a MacBook Pro 17 running Mac OS 10.7.5. It does
not occur when running LibreOffice 3.4.4. The test file was created
with LibreOffice 3.4.4.

Steps to reproduce, w/ current and expected behavior:

- open LibreOffice4.0.1.2_DeleteBCBreaksBHCondFormat.ods
- confirm blue background in cell BH6
- select cell BH6
  - "Format | Conditional Formatting | Condition..." (LibreOffice
    4.0.1.2) or "Format | Conditional Formatting..." (LibreOffice
    3.4.4)
    - click on Yes (LibreOffice 4.0.1.2 only)
    - confirm condition 1: cell value is equal to $Sheet1.BH$1
    - click on Cancel
- select column BC
- "Edit | Delete Cells..."
- NOTE WHITE BACKGROUND IN CELL BG6
  - should be blue

- select cell BG6
  - "Format | Conditional Formatting | Condition..." (LibreOffice
    4.0.1.2) or "Format | Conditional Formatting..." (LibreOffice
    3.4.4)
    - click on Yes (LibreOffice 4.0.1.2 only)
    - NOTE BROKEN REFERENCE IN CONDITION 1: cell value is equal to
      $Sheet1.#REF!$1
      - should be: ... $Sheet1.BG$1
    - click on Cancel

- furthermore, the problem is not undoable:
  - "Edit | Undo"
  - NOTE WHITE BACKGROUND IN CELL BH6

Operating System: Mac OS X
Version: 4.0.1.2 release
Last worked in: 3.4.4 release
Comment 1 Markus Mohrhard 2013-03-25 08:41:56 UTC

*** This bug has been marked as a duplicate of bug 62206 ***