Bug 93878 - save formulas in xls (A:A)
Summary: save formulas in xls (A:A)
Status: CLOSED DUPLICATE of bug 83746
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.1.1 rc
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 93934 (view as bug list)
Depends on:
Blocks:
 
Reported: 2015-09-03 07:59 UTC by dazky
Modified: 2016-05-19 17:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Test.ods (9.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-09-03 07:59 UTC, dazky 		Details
Test-save1.xls (7.00 KB, application/vnd.ms-excel)
2015-09-03 08:00 UTC, dazky 		Details
Test-save2.xls (7.00 KB, application/vnd.ms-excel)
2015-09-03 08:00 UTC, dazky 		Details
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 dazky 2015-09-03 07:59:25 UTC 
Created attachment 118375 [details]
Test.ods

Hello,
I think, that is bug in save to xls format.

Formulas in odt format works for many saves
SUMIFS(C:C;A:A;$E$1;B:B;$E$2)

first save to xls
SUMIFS(C$1:C$983040;A$1:A$983040;$E$1;B$1:B$983040;$E$2)

second save xls to xls
SUMIFS(#REF!$#REF!:#REF!$#REF!;#REF!$#REF!:#REF!$#REF!;$E$1;#REF!$#REF!:#REF!$#REF!;$E$2)

Files in attachment (Test.ods, Test-1.xls, Test-2.xls)

I think that problem:
A:A => 
save to xls convert formula => A$1:A$983040 
=> save to xls convert formula => #REF!$#REF!:#REF!$#REF!



David
Comment 1 dazky 2015-09-03 08:00:14 UTC 
Created attachment 118376 [details]
Test-save1.xls
Comment 2 dazky 2015-09-03 08:00:32 UTC 
Created attachment 118377 [details]
Test-save2.xls
Comment 3 raal 2015-09-03 14:46:39 UTC 
reproducible with Version: 5.1.0.0.alpha1+
Build ID: b2363e98af7b0281279617e43b8fec5b898b9120
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2015-08-26_00:57:35
Comment 4 m_a_riosv 2015-09-05 12:11:44 UTC 
*** Bug 93934 has been marked as a duplicate of this bug. ***
Comment 5 Eike Rathke 2016-05-19 17:33:42 UTC 

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