Ask Your Question

Why won't calc calculate...anything? [closed]

asked 2013-10-26 22:02:47 +0200

Cthulhu gravatar image

updated 2015-11-12 14:52:11 +0200

Alex Kemp gravatar image

Problem description:

Calc will not calculate anything, but I found this out during matrix multiplication and inverse. Steps to reproduce:

Scenario 1:

  1. ....Make two 2x2 matrices with any numbers in them.

  2. ....Select empty cell for desired output, type in "=(select and drag to encompass the first 2x2 matrix),(select and drag to encompass the first 2x2 matrix)

  3. ....Hit ctrl+shift+enter

Scenario 2:

1....Enter "=10*9" into cell. 2....Hit enter.

Current behavior:

Scenario 1:

Only displays #### in all of the matrix outputs. Also, when viewed in the entry field above it only lists the equation entered, not the solution. Thus rendering the application worthless for my purposes.

Scenario 2:

It only displays the input value "=10*9". Which renders it useless for my purposes.

Expected behavior:

Scenario 1:

The properly calculate the matrix equation entered in. Or to do any type of mathematical function.

Scenario 2:

In theory it should have "90" in the cell. Yet it does not.

Is there a setting that I need to adjust for it to actually do calculations?

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 14:52:42.153106


Enter "=10*9" .... I hope you are not typing the quotes, no?

hernan gravatar imagehernan ( 2013-10-29 15:03:35 +0200 )edit

3 Answers

Sort by » oldest newest most voted

answered 2013-10-28 08:06:34 +0200

JohnSUN gravatar image

Please make sure this option is set to OFF

View Formulas

edit flag offensive delete link more

answered 2013-10-27 00:06:11 +0200

oweng gravatar image

updated 2013-10-27 23:35:32 +0200

Sounds like the cells are formatted as Text rather than Number. When =10*9 displays instead of the resultant value (90) is it left or right-aligned? Left-aligned means it is likely the cell is formatted as Text. Highlight the cell, Format > Cells... > on the Numbers tab, what is the Category set to?

>Select empty cell for desired output, type in "=(select and drag to encompass the first 2x2 matrix)

I am not clear what you are trying to do here. Typing "=" in a cell and then making a 2x2 cell selection will result in a formula like =A1:B2 which will then display #VALUE! as it is not a valid reference.

EDIT: Apologies for my initial misreading of the array entry method (CTRL+SHIFT+ENTER rather than simply ENTER).

edit flag offensive delete link more


@karolus, thanks for pointing this out. I miss-read the initial description. I will amend my answer.

oweng gravatar imageoweng ( 2013-10-27 23:31:15 +0200 )edit

answered 2013-10-26 22:25:46 +0200

horst gravatar image

You mentioned to show only #### which is an indicator that your cells are to small.

Right click on a column and select "Optimal width" this should solve your problem.

The input line always shows your entry not the result.

edit flag offensive delete link more


This did not work. It only displays the command in each cell. It doesn't actually calculate anything. Even simple arithmetic.

Cthulhu gravatar imageCthulhu ( 2013-10-26 22:34:38 +0200 )edit

Question Tools

1 follower


Asked: 2013-10-26 22:02:47 +0200

Seen: 1,123 times

Last updated: Oct 28 '13