Ask Your Question

array formulas [closed]

asked 2012-09-17 17:37:54 +0200

lblibre gravatar image

updated 2015-10-18 02:35:28 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 02:35:07.496809


I think there are improvements in this area on the latest releases 3.6.2.

m.a.riosv gravatar imagem.a.riosv ( 2012-09-17 21:33:16 +0200 )edit

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

moggi gravatar imagemoggi ( 2012-09-18 01:39:28 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2012-09-17 23:22:11 +0200

rl gravatar image

I have actually used array formulas in LibreOffice recently and they worked as expected.

Have you tried LibreOffice

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

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.

edit flag offensive delete link more

answered 2012-09-19 02:31:21 +0200

lblibre gravatar image

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.

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.

edit flag offensive delete link more


Bug appears to be fdo#55071 - Array Formulas Do Not Work, with current status of NEW.

qubit gravatar imagequbit ( 2013-02-23 07:04:06 +0200 )edit

Question Tools


Asked: 2012-09-17 17:37:54 +0200

Seen: 1,183 times

Last updated: Sep 19 '12