Bug 159676 - Formula will not show results & tried using "Data Sources" & it doesn't work
Summary: Formula will not show results & tried using "Data Sources" & it doesn't work
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2 all versions
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-02-10 19:42 UTC by leop10
Modified: 2024-02-10 19:53 UTC (History)
0 users

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 leop10 2024-02-10 19:42:56 UTC
Description:
Libra Office Calc:  The first problem  has to do with formulas are not showing results they only show the formula.… To add more crazyness to this topic… Under the “View” option there is a selection labeled “Data Sources” That used to allow you to switch from viewing either the formula or the results. Now what is does is pop up at the top of the page called “Bibliography” and making that worse, it’s not obvious how to remove it… you need to go back and re-select “Data Sources” I also tried deleting the Lebreoffice app and re-installing. Now running version 24.2.0.3 … nothing got better. MAJOR BUGS IN THE CODE"
Somebody HELP!

Steps to Reproduce:
1.from a different cell Select copy from a cell with something in it. 
2.results in displaying the formula
3.found nothing to be able to view the result

Actual Results:
Displays the formula

Expected Results:
Nothing works


Reproducible: Always


User Profile Reset: No

Additional Info:
either display the result or allow selecting either the result or the formula.
Comment 1 ady 2024-02-10 19:53:30 UTC
Open the specific Calc document. Go to menu View > Show Formula.

If that is not enough, save and close the document and in LibreOffice go to menu Help > Restart in Safe Mode. Test what happens in Safe Mode with the same file.