| Summary: | EDITING: Basic mathematical calculations, array calculations. | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Cthulhu <conscriptchampion> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTABUG | ||
| Severity: | normal | CC: | rb.henschel |
| Priority: | medium | ||
| Version: | 4.1.1.2 release | ||
| Hardware: | Other | ||
| OS: | Linux (All) | ||
| Whiteboard: | BSA | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | calc sheet with failed matrix multiplication, and basic math failures as well. | ||
I suppose that you tried the PRODUITMAT function : "=PRODUITMAT(range1;range2)", not the questionnable "=range1,range2".
Of course you have checked ;-) :
- that "Autocalculate" is on (Tools > Cell Content > Autocalculate),
- that the 2 columns for the result of the PRODUITMAT are large enough.
When you examine a cell displaying the result of a formula, the "field above" ("ligne de saisie" in French ; I don't know its english name) shows the formula, not the result, this is the normal way.
Goto Tools > Options > LO Calc > View. Make sure that "Formulas" is not checked in section 'Display'. (In reply to comment #2) > Goto Tools > Options > LO Calc > View. Make sure that "Formulas" is not > checked in section 'Display'. ...Yep. That was it. I'll go and get my Darwin award now... Thanks for the help guys this has put a knot in a lot of things. |
Created attachment 88117 [details] calc sheet with failed matrix multiplication, and basic math failures as well. Problem description: Updated to the most recent version and all hell broke loose. Calc will not calculate anything, but I found this out during matrix multiplication and inverse. It also will not do simple arithmetic. 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. Yes it does not. Is there a setting that I need to adjust for it to actually do calculations? Operating System: Ubuntu Version: 4.1.1.2 release