Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 23 Feb 2013 07:04:06 +0100array formulashttps://ask.libreoffice.org/en/question/6085/array-formulas/I have a workbook developed in Excel 2007. I save it as an Excel 97-2003 format for my users. The workbook uses many array formulas. These formulas work fine in Libre Calc3.3 but they do not work in Libre Calc 3.5.
I cannot find any information about this on your known issues website. Is there a fix?
Mon, 17 Sep 2012 17:37:54 +0200https://ask.libreoffice.org/en/question/6085/array-formulas/Comment by m.a.riosv for <p>I have a workbook developed in Excel 2007. I save it as an Excel 97-2003 format for my users. The workbook uses many array formulas. These formulas work fine in Libre Calc3.3 but they do not work in Libre Calc 3.5.
I cannot find any information about this on your known issues website. Is there a fix?</p>
https://ask.libreoffice.org/en/question/6085/array-formulas/?comment=6096#post-id-6096I think there are improvements in this area on the latest releases 3.6.2.Mon, 17 Sep 2012 21:33:16 +0200https://ask.libreoffice.org/en/question/6085/array-formulas/?comment=6096#post-id-6096Comment by moggi for <p>I have a workbook developed in Excel 2007. I save it as an Excel 97-2003 format for my users. The workbook uses many array formulas. These formulas work fine in Libre Calc3.3 but they do not work in Libre Calc 3.5.
I cannot find any information about this on your known issues website. Is there a fix?</p>
https://ask.libreoffice.org/en/question/6085/array-formulas/?comment=6114#post-id-6114If you can't open it correctly in 3.6.2 but you can in 3.3 please open a bug report with a test document.Tue, 18 Sep 2012 01:39:28 +0200https://ask.libreoffice.org/en/question/6085/array-formulas/?comment=6114#post-id-6114Answer by rl for <p>I have a workbook developed in Excel 2007. I save it as an Excel 97-2003 format for my users. The workbook uses many array formulas. These formulas work fine in Libre Calc3.3 but they do not work in Libre Calc 3.5.
I cannot find any information about this on your known issues website. Is there a fix?</p>
https://ask.libreoffice.org/en/question/6085/array-formulas/?answer=6107#post-id-6107I have actually used array formulas in LibreOffice recently and they worked as expected.
Have you tried LibreOffice 3.6.1.2?
At least I can not reproduce your problem by creating a (small) spreadsheet in Excel 2010, saving it in Excel 97-2003 format and opening it in LibreOffice 3.6.1.2.
So, either your problem has been fixed in the latest LibreOffice release, or there's something special about your file, like, say, the functions you used in those formulas, or the number of array formulas in your file.
Mon, 17 Sep 2012 23:22:11 +0200https://ask.libreoffice.org/en/question/6085/array-formulas/?answer=6107#post-id-6107Answer by lblibre for <p>I have a workbook developed in Excel 2007. I save it as an Excel 97-2003 format for my users. The workbook uses many array formulas. These formulas work fine in Libre Calc3.3 but they do not work in Libre Calc 3.5.
I cannot find any information about this on your known issues website. Is there a fix?</p>
https://ask.libreoffice.org/en/question/6085/array-formulas/?answer=6153#post-id-6153I have the same problem in Calc 3.6.1. I've submitted a bug report. I took one sheet of my multi-sheet workbook and submitted it with the report.
I use the Offset function to define a named range, so if the number of rows changes, the range is always defined. Thats the only thing I can think of that may be part of the problem. I am still baffled why it works in Calc 3.3 and not the later versions.
Wed, 19 Sep 2012 02:31:21 +0200https://ask.libreoffice.org/en/question/6085/array-formulas/?answer=6153#post-id-6153Comment by qubit for <p>I have the same problem in Calc 3.6.1. I've submitted a bug report. I took one sheet of my multi-sheet workbook and submitted it with the report.</p>
<p>I use the Offset function to define a named range, so if the number of rows changes, the range is always defined. Thats the only thing I can think of that may be part of the problem. I am still baffled why it works in Calc 3.3 and not the later versions.</p>
https://ask.libreoffice.org/en/question/6085/array-formulas/?comment=12962#post-id-12962Bug appears to be fdo#55071 - *Array Formulas Do Not Work*, with current status of NEW.Sat, 23 Feb 2013 07:04:06 +0100https://ask.libreoffice.org/en/question/6085/array-formulas/?comment=12962#post-id-12962