https://bugs.documentfoundation.org/show_bug.cgi?id=156174
Bug ID: 156174
Summary: Bug in formulas if delete a sheet
Product: LibreOffice
Version: 7.5.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
3 sheets in the document :
'Elements'
'UPN'
'Feuille13'
Formula in Sheet 'Elements' : = RECHERCHEV(R86;UPN;8)
If I delete the sheet 'Feuille13' (but keeping the sheet 'UPN') then the
formula here above becomes :
=RECHERCHEV(R86;#NOM ?;8)
While the sheet 'UPN' still exists
Steps to Reproduce:
0. 3 sheets in a file : A, B, C
1.in sheet A create formula with link to sheet B
2.delete sheet C
3.but in formula with link from A to B
Actual Results:
formula n sheet A is transformed within a lost link to an inexisting sheet,
which is wrong since the sheet still exist
Expected Results:
the link should not be impacted by deletion of sheet C
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.5.3.2 (X86_64) / LibreOffice Community
Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
