Bug 132455 - REF error after undo sheet deletion. Hard recalculate doens't fix it
Summary: REF error after undo sheet deletion. Hard recalculate doens't fix it
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: Cell-Reference
  Show dependency treegraph
 
Reported: 2020-04-27 11:43 UTC by Telesto
Modified: 2020-08-03 21:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2020-04-27 11:43:10 UTC
Description:
REF error after undo sheet deletion. Hard recalculate doens't fix it

Steps to Reproduce:
1. Open attachment 154545 [details]
2. Remove FiltrageVent
3. CTRL+Z -> Wait a long time
4. Notice sheet Comparison showing REF error 

Actual Results:
REF-error

Expected Results:
No ref-error


Reproducible: Always


User Profile Reset: No



Additional Info:
Found in
Version: 7.0.0.0.alpha0+ (x64)
Build ID: f924658e45f256544e43c3fdb2af9b585d0f0933
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win; 
Locale: nl-NL (nl_NL); UI-Language: en-US
Calc: threaded

and in 4.4.7.2

not in 3.5.7.2
Comment 1 Xisco Faulí 2020-05-13 11:08:05 UTC
Hi Telesto,
Would it be possible to get a reduced reproducer ?
Comment 2 Xisco Faulí 2020-06-17 12:02:58 UTC
(In reply to Xisco Faulí from comment #1)
> Hi Telesto,
> Would it be possible to get a reduced reproducer ?

Setting to NEEDINO
Comment 3 Telesto 2020-06-17 13:07:10 UTC
Nope, sheet is locked with a password
Comment 4 b. 2020-06-18 15:46:32 UTC
repro with: 

Version: 7.1.0.0.alpha0+ (x64)
Build ID: a201ab6f47c2d5a7ba4c5f998b0aa231cae82010
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL

small reproducer with simple formula with 'constructed indirect' to other sheet fails - to fail- will try complex formulas later ...