Bug 64775 - cell contains now a N/A value instead of being empty
Summary: cell contains now a N/A value instead of being empty
Status: RESOLVED DUPLICATE of bug 53274
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-05-19 21:00 UTC by Jorendc
Modified: 2013-05-19 22:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
test document (441.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-19 21:00 UTC, Jorendc 		Details
how it looks in LibreOffice 3.5.0 (127.58 KB, image/png)
2013-05-19 21:03 UTC, Jorendc 		Details
how it looks in LibreOffice 4.0.3.3 (160.60 KB, image/png)
2013-05-19 21:04 UTC, Jorendc 		Details
how it looks like in LibreOffice 4.0.3.3 (159.36 KB, image/png)
2013-05-19 22:17 UTC, Jorendc 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Jorendc 2013-05-19 21:00:40 UTC 
Created attachment 79552 [details]
test document

Using Linux Mint 15 x64 with LibreOffice 4.0.3.3 :

How to reproduce:
* Open attached ods file
* Go to sheet 'Venduto Constanti'
* Cell 'AW2' has value N/A

Opening the same file using LibreOffice 3.5.x:
* Cell 'AW2' is just empty

Kind regards,
Joren
Comment 1 Jorendc 2013-05-19 21:03:39 UTC 
Created attachment 79553 [details]
how it looks in LibreOffice 3.5.0
Comment 2 Jorendc 2013-05-19 21:04:10 UTC 
Created attachment 79554 [details]
how it looks in LibreOffice 4.0.3.3
Comment 3 Jorendc 2013-05-19 22:17:00 UTC 
Created attachment 79556 [details]
how it looks like in LibreOffice 4.0.3.3
Comment 4 m_a_riosv 2013-05-19 22:40:10 UTC 
Hi Jorendc,
The issue is as you can see in the bug:
https://bugs.freedesktop.org/show_bug.cgi?id=53274

You can solve with the IFNA() function added in 4.x version.

*** This bug has been marked as a duplicate of bug 53274 ***