Bug 99432 - =Rows suddenly doesn't work anymore
Summary: =Rows suddenly doesn't work anymore
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86 (IA32) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-04-21 11:04 UTC by Peter Fackelmann
Modified: 2016-05-08 15:32 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Screenshot (42.51 KB, application/pdf)
2016-04-21 11:04 UTC, Peter Fackelmann 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Fackelmann 2016-04-21 11:04:19 UTC 
Created attachment 124547 [details]
Screenshot

All of a sudden the ROWS-function stopped to work. See

=ROWS(A5:A16)

shows

###

What do you propose?

Thank you

Kind regards

Peter Fackelmann
Comment 1 JoNi 2016-04-21 20:04:03 UTC 
Hi, Peter

### means the column is not wide enough to show your result.
Just double click the bar between column header A and B,
or drag it to widen the column.


marking as not a bug.
if you don't agree or still have the problem, feel free to reopen the bug.
Comment 2 Peter Fackelmann 2016-04-25 11:59:28 UTC 
not quite so.
This phenomenon started out of the blue - no problem before.
Checking again I found

Data - Calculate - Auto Calculate checked.

I changed to

Formula to Value

then the value appeared and the function switched to Auto Calculate again.

Value still visible with field width matching the value.

So, why did the Calculate function act this way?
Comment 3 Peter Fackelmann 2016-05-08 15:32:10 UTC 
The problem is solved.
One has to uncheck Prefs-Calc-View-Display Formulas.
In the new v 5.1.2.2 it was checked (not by me!)

Peter Fackelmann