Bug 96045 - Imported formulas from Excel don't work until you copy paste the exact same formula
Summary: Imported formulas from Excel don't work until you copy paste the exact same f...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-11-24 16:13 UTC by Jonathan Ernst
Modified: 2016-09-12 12:22 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Test file (20.58 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-11-24 16:13 UTC, Jonathan Ernst
Details
Screenshot file content. (68.97 KB, image/png)
2015-11-24 22:20 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Ernst 2015-11-24 16:13:04 UTC
Created attachment 120766 [details]
Test file

See attached file converted from Excel. 

The strange thing is that copy pasting the #NAME? formulas make them work again.
Comment 1 m_a_riosv 2015-11-24 22:20:23 UTC
Created attachment 120771 [details]
Screenshot file content.

Hi @Jonathan, thanks for reporting.

Looking into the content file that functions were saved with the French (attaced screenshot) name not with the default name, so they are not open properly. 

Maybe the file was open and saved with a program version that not support that function.
Comment 2 Xisco Faulí 2016-09-11 21:12:25 UTC
Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INVALID
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

Sun, 11 Sep 2016 21:43:24 +0200