<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - FILESAVE: LibreOffice Calc won't save AVERAGE when it contains 31 cells or data (.xls file)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114375">114375</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>FILESAVE: LibreOffice Calc won't save AVERAGE when it contains 31 cells or data (.xls file)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.1.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>gatoso@grrlz.net
</td>
</tr></table>
<p>
<div>
<pre>Description:
LibreOffice Calc won't save AVERAGE when it contains 31 cells or data.
When I calculate an average which contains 31 cells or data, I save the file in
a .xls format and reopen the file, the average is not in cell where I put it,
instead I see the expression #N/A and in the input line =NA(). Please, note
that each data with which it was calculated is also another average of another
data.
I attach the corresponding file with the data set. You can see the sell with
the average that is failing at Q26
I am on Linux Mint 18.2, Sonya (Ubuntu 16.04, Xenial), 64 bits, KDE 5.8.8, and
I use LibreOffice 5.1.6.2 Build ID: 1:5.1.6~rc2-0ubuntu1~xenial2
File:
<a href="https://yadi.sk/i/IIFJ3azQ3QUEdF">https://yadi.sk/i/IIFJ3azQ3QUEdF</a>
Steps to Reproduce:
1.Open the file
2.In any cell, in its Input line, put the following:
=AVERAGE(P25,P49,P73,P97,P121,P145,P169,P193,P217,P241,P265,P289,P313,P337,P361,P385,P409,P433,P457,P481,P505,P529,P505,P553,P577,P601,P625,P649,P673,P697,P721).
Each of these cells are, at the same time, averages of data
3.Save
4.Open the file again
5.You will see at the cell #N/A and in the input line =NA()
Actual Results:
LibreOffice Calc won't save averages with 31 or more data that is, at the same
time, another average of another data, in .xls files
Expected Results:
LibreOffice Calc save averages with 31 or more data that is, at the same time,
another average of another data, in .xls files
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
Terminal output by opening the file, saving the changes and exiting:
$ LC_ALL=C libreoffice
javaldx: Could not find a Java Runtime Environment!
Warning: failed to read path from javaldx
(soffice:17210): Gtk-WARNING **: Unable to locate theme engine in module_path:
"adwaita",
(soffice:17210): Gtk-WARNING **: Unable to locate theme engine in module_path:
"adwaita",
(soffice:17210): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
(soffice:17210): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
W: Unknown node under /registry/extlang: deprecated
W: Unknown node under /registry/grandfathered: comments
W: Unknown node under /registry/grandfathered: comments
** (soffice:17210): WARNING **: Invalidate all children called
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 36
** (soffice:17210): WARNING **: Unknown event notification 34
** (soffice:17210): WARNING **: Unknown event notification 36
Terminal output by reopening the file:
$ LC_ALL=C libreoffice
javaldx: Could not find a Java Runtime Environment!
Warning: failed to read path from javaldx
(soffice:17381): Gtk-WARNING **: Unable to locate theme engine in module_path:
"adwaita",
(soffice:17381): Gtk-WARNING **: Unable to locate theme engine in module_path:
"adwaita",
(soffice:17381): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
(soffice:17381): Gdk-WARNING **: gdk_window_set_icon_list: icons too large
W: Unknown node under /registry/extlang: deprecated
W: Unknown node under /registry/grandfathered: comments
W: Unknown node under /registry/grandfathered: comments
** (soffice:17381): WARNING **: Invalidate all children called
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101
Firefox/57.0</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>