Why won't calc 4.1.2.3 calculate...anything?

[Cthulhu]

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?

[hernan]

Enter “=10*9” … I hope you are not typing the quotes, no?

[JohnSUN]

Please make sure this option is set to OFF

[horst]

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.

[Cthulhu]

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

[oweng]

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).

[oweng]

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