<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 - XLSX Validation with cells referencing themselves always gives error"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=125914">125914</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>XLSX Validation with cells referencing themselves always gives error
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>4.0.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Keywords</th>
<td>filter:xlsx
</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>baron@caesar.elte.hu
</td>
</tr>
<tr>
<th>Blocks</th>
<td>108897, 108988
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=152179" name="attach_152179" title="Sample XLSX">attachment 152179</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=152179&action=edit" title="Sample XLSX">[details]</a></span>
Sample XLSX
Open the attached spreadsheet, created in Excel.
In the B column, next to the description validation criteria is set with "equal
to" setting that refers to the cell itself. This means only the basic criteria
is taken into account (whole number, decimal, date, time), and any such entry
can be entered.
Enter values like:
- 645789
- -1956.56
- 1999-08-31
- 23:59
These are all allowed in Excel, but none of them is allowed in Calc. Note that
in Excel the value criteria can be a cell reference, however Calc shows cell
references as values (eg. "B1" instead of "=B1"), and doesn't allow selecting a
referenced cell.
Observed using LO 6.4.0.0.alpha0+ (95462a02a3aee1e3e7f9aa8fc50ba25fee3fa592),
4.0.0.3 / Windows 7.</pre>
</div>
</p>
<div id="referenced">
<hr style="border: 1px dashed #969696">
<b>Referenced Bugs:</b>
<ul>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] XLSX (OOXML) bug tracker"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108897">Bug 108897</a>] [META] XLSX (OOXML) bug tracker
</li>
<li>
[<a class="bz_bug_link
bz_status_NEW "
title="NEW - [META] Validity-related bugs and enhancements"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108988">Bug 108988</a>] [META] Validity-related bugs and enhancements
</li>
</ul>
</div>
<br>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>