https://bugs.documentfoundation.org/show_bug.cgi?id=100197
Bug ID: 100197
Summary: Scenario Hyperlinks do not work.
Product: LibreOffice
Version: 5.1.1.3 release
Hardware: Other
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 125461
--> https://bugs.documentfoundation.org/attachment.cgi?id=125461&action=edit
Guide how to reproduce the bug is also in the document itself.
Hyperlinks to Scenarios in the same worksheet doesn't work in LO Calc 5.1.3.2.
Create a Scenario, and make a clickable Hyperlink for the Scenario in the same
document. The Scenario can be recalled from the Navigator, but the links in the
document itself will not work, wether they are created by dragging from the
Navigator, or by Cmd K (ctrl K in windows).
In the sample document I created a Scenario with empty yellow cells. To
reproduce the issue:
1. Type anything in any yellow cell(s).
2. Cmd click (ctrl click in windows) the hyperlink "Clear_Yellows".
- Nothing happens.
- This should have loaded the Scenario in which the yellow cells are empty.
3. Open the Navigator (F5) and click the "Scenarios" button.
4. Double-click the Scenario "Clear_Yellows".
- The Scenario is now loaded and the yellow cells are cleared.
This bug causes data loss in two situations:
DATA LOSS 1 (permanent): If I enter data in the yellow fields, save the
document as .xslx and reopen, the data that was entered is lost. I guess the
empty Scenario was force-loaded overwriting the data that was in the cells when
saving.
DATA LOSS 2 (possible): If I save the Spreadsheet as .xls and reopen, clicking
on the link creates a new Sheet with the Scenario data. The Navigator still
shows the Scenario available for the original sheet, but if the second sheet is
deleted, the Scenario for the first sheet is deleted as well.
-------------------
Using a MacBook Pro 15" 2010 running OSX 10.11.5.
Reproduced the bug in LO 5.1.1.3, 5.1.3.2 and LODev May-7-2016:
master-2016-05-07_00.24.03_LibreOfficeDev_5.2.0.0.alpha1_MacOS_x86-64
NOTE: The latest snapshot build is slightly different:
(master-2016-06-01_00.32.05_LibreOfficeDev_5.3.0.0.alpha0_MacOS_x86-64)
- A Hyperlink created in the new LODev by dragging from Navigator opens the
document at the SAVED state in a new window, unless I save the document first.
Then it does nothing. This seems to happen with .odt and .xlsx, but not .xls.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
