Bug 145597 - Receiving ###
Summary: Receiving ###
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.2.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-11-09 07:41 UTC by Joel Collier
Modified: 2021-11-09 09:05 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 Joel Collier 2021-11-09 07:41:47 UTC
I was creating a spreadsheet with Calc. In one cell, I put together a formula using the simple SUM function and I received ###. In another cell, I was using the AVERAGE function and received the same result. In both Calc and other spreadsheets, when I received ###, it meant that there was not enough room in the cell for the all the digits of the number. In previous experiences, when the cell size was widened, the numbers were displayed. In this case, when I widened the cell, it put the formula on display, but didn't calculate the formula. I had a few other spreadsheets that I created with an earlier version of Calc. When opening them in 7.2.2.2, I no longer received the the result of the formula. I did receive the ### and when I widen the cell, the formula was being displayed.
Comment 1 Xisco Faulí 2021-11-09 09:05:42 UTC
### means there is not enough space to display the information. Just make the cell wider.
Closing as RESOLVED NOTABUG