Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenFri, 04 May 2018 13:57:09 +0200mdeterm solving matrix determinanthttps://ask.libreoffice.org/en/question/154004/mdeterm-solving-matrix-determinant/Hi, I've stumbled accros with a strange issue, using LO Calc in spreadsheet calculating matrices, especially a determinant of the matrix with mdeterm() function. The function gives wrong answer. So here is the data in the calc file: https://drive.google.com/open?id=1S4ptB2AqvPya9fIjYOQhclOUZmeoUG76
Octave gives answer for this matrix Det(A)=23503.602875
(matrix for solving in octave: A=[10, 22.5, 71.25; 22.5, 71.25, 253.13; 71.25, **235.13**, 958.31]) **error in third row a32 index**
I've checked with [wolframalpha](http://www.wolframalpha.com/input/?i=det+%7B%7B10,+22.5,+71.25%7D,+%7B+22.5,+71.25,+253.13%7D,+%7B71.25,+235.13,+958.31%7D%7D) and gives the same answer as Octave.
I found similar issue with this function in the [buggzila ](https://bugs.documentfoundation.org/show_bug.cgi?id=32834). But it is shown, that this bug is fixed.
So, why do LO Calc gives me wrong answer? Any suggestions?
P.S. LO version: 5.4.6.2 (x64)OSS-userFri, 04 May 2018 13:57:09 +0200https://ask.libreoffice.org/en/question/154004/Calc: find and replace possible in matrix-formulas?https://ask.libreoffice.org/en/question/134251/calc-find-and-replace-possible-in-matrix-formulas/As described in ['SheetName.'-bug](https://ask.libreoffice.org/en/question/72701/calc-formulas-automagically-extended-with-sheet-name/) LibreOffice Calc continuously makes own files illegible by inserting 'SheetName.' to every cell-reference.
As workaround to manually repair spreadsheets (at least temporary) a possibility to **use find and replace** also **for matrix-formulas** would be very helpful.
Does any possibility exist?milanTue, 10 Oct 2017 19:17:49 +0200https://ask.libreoffice.org/en/question/134251/Libre office conditional sum no more works for newer versions (italian)https://ask.libreoffice.org/en/question/81588/libre-office-conditional-sum-no-more-works-for-newer-versions-italian/Hi all, I'm using for a long time a spreadsheet in LibreOffice Calc with formulas of this type:
{=SOMMA( (H27:H3001=1)*(MESE(A27:A3001)=N20)*J27:J3001 )}
to perform a conditional sum over a range of cells, but from version 5 I get the '#value!' error, so I can't use newer versions of the product.
Is there a way to make compatible the formula with newer versions?
(The formula works on Excel too).
ThanksErmannoFFri, 11 Nov 2016 12:45:38 +0100https://ask.libreoffice.org/en/question/81588/Complex Matriceshttps://ask.libreoffice.org/en/question/15199/complex-matrices/Hey All---
I know that this is easy to do with, e.g., Octave or Sage, but I had wanted to compute some operator equations and was surprised not to find a way to deal with complex matrices in Calc.
Even sumproduct does not work for complex entries.
Is there any remedy for this?TumericTJMon, 25 Mar 2013 04:24:01 +0100https://ask.libreoffice.org/en/question/15199/