Bug 63671 - Spredsheet Formula missing after upgrade from 3.6 to 4.01 & 4.0.2.2
Summary: Spredsheet Formula missing after upgrade from 3.6 to 4.01 & 4.0.2.2
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-04-18 07:21 UTC by AVAGO
Modified: 2013-11-21 08:16 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
With Formula Missing (65.50 KB, application/msword)
2013-04-18 07:21 UTC, AVAGO
Details
Spreadsheet with Formula missing (119.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-04-18 07:25 UTC, AVAGO
Details
attachment-30074-0.html (9.16 KB, text/html)
2013-04-19 07:08 UTC, AVAGO
Details
attachment-30074-1.dat (1 bytes, multipart/alternative)
2013-04-19 07:08 UTC, AVAGO
Details
17576078.gif (60.60 KB, image/gif)
2013-04-19 07:08 UTC, AVAGO
Details
17370477.gif (25.16 KB, image/gif)
2013-04-19 07:08 UTC, AVAGO
Details
graycol.gif (105 bytes, image/gif)
2013-04-19 07:08 UTC, AVAGO
Details
pic14771.gif (1.23 KB, image/gif)
2013-04-19 07:08 UTC, AVAGO
Details
ecblank.gif (45 bytes, image/gif)
2013-04-19 07:08 UTC, AVAGO
Details
attachment-31850-0.html (4.62 KB, text/html)
2013-05-01 07:40 UTC, AVAGO
Details
attachment-31850-1.dat (1 bytes, multipart/alternative)
2013-05-01 07:40 UTC, AVAGO
Details
14172234.gif (60.20 KB, image/gif)
2013-05-01 07:40 UTC, AVAGO
Details
14050090.gif (25.14 KB, image/gif)
2013-05-01 07:40 UTC, AVAGO
Details
14379698.gif (15.41 KB, image/gif)
2013-05-01 07:40 UTC, AVAGO
Details
14875716.gif (15.41 KB, image/gif)
2013-05-01 07:40 UTC, AVAGO
Details
Production Plan 2013.ods (119.44 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-01 07:40 UTC, AVAGO
Details
Production Plan 2013.xls (327.50 KB, application/msexcel)
2013-05-01 07:40 UTC, AVAGO
Details
Sample file recreated the chart. (127.91 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-01 11:14 UTC, m_a_riosv
Details
attachment-5305-0.html (7.92 KB, text/html)
2013-05-01 11:27 UTC, AVAGO
Details
attachment-5305-1.dat (1 bytes, multipart/alternative)
2013-05-01 11:27 UTC, AVAGO
Details
graycol.gif (105 bytes, image/gif)
2013-05-01 11:27 UTC, AVAGO
Details
pic03168.gif (1.23 KB, image/gif)
2013-05-01 11:27 UTC, AVAGO
Details
ecblank.gif (45 bytes, image/gif)
2013-05-01 11:27 UTC, AVAGO
Details

Note You need to log in before you can comment on or make changes to this bug.
Description AVAGO 2013-04-18 07:21:47 UTC
Created attachment 78167 [details]
With Formula Missing

A Spread sheet has been created in V3.6 with formual in , Libre office upgraded to 4.01 and all the formula had gone, Re-created spreadsheet in V4.01 saved teested and working, Then upgraded to V.4.0.2.2 and all the formula has gone again,
I have included the Spreadsheet ( Called Production Plan 2013 ) which when opened in 4.0.2.2 the formula is missing, I have also attached some scrren shots of what it should look like when in V3.6 and then after being redone in V4.01.
Comment 1 AVAGO 2013-04-18 07:25:30 UTC
Created attachment 78168 [details]
Spreadsheet with Formula missing
Comment 2 m_a_riosv 2013-04-19 00:16:50 UTC
Hi AVAGO, thank for reporting,

Please where in the spreadsheet and what formula is missing?.
Comment 3 AVAGO 2013-04-19 07:08:21 UTC
Created attachment 78210 [details]
attachment-30074-0.html

Hi Thanks for getting back to me

when you open the Production plan and go to total info it should look like
this





The spread sheet was created in V3.6 but when upgraded to V4.01 the charts
became blank, the for was recreated in V4.01  but then when upgraded to
V4.0.2.2 the charts became blank again


Regards

Phil
Support Engineer
Microlise Ltd
Telephone: 01773 537000
Direct: 01773 537345

phil.storey@microlise.com
http://www.microlise.com/

Please consider the environment before printing this e-mail


                                                                           
             bugzilla-daemon@f                                             
             reedesktop.org                                                
                                                                        To 
             19/04/2013 01:16          phil.storey@microlise.com,          
                                                                        cc 
                                                                           
                                                                   Subject 
                                       [Bug 63671] Spredsheet Formula      
                                       missing after upgrade from 3.6 to   
                                       4.01 & 4.0.2.2                      
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




mariosv changed bug 63671
|---------------+------------------+--------------------------|
|               |                  |                          |
|      What     |      Removed     |           Added          |
|               |                  |                          |
|---------------+------------------+--------------------------|
|               |                  |                          |
|        Status |  UNCONFIRMED     |  NEEDINFO                |
|               |                  |                          |
|---------------+------------------+--------------------------|
|               |                  |                          |
|            CC |                  |  mariosv@miguelangel.mob |
|               |                  |  i                       |
|               |                  |                          |
|---------------+------------------+--------------------------|
|               |                  |                          |
|          Ever |                  |  1                       |
|     confirmed |                  |                          |
|               |                  |                          |
|---------------+------------------+--------------------------|



Comment # 2 on bug 63671 from mariosv
Hi AVAGO, thank for reporting,

Please where in the spreadsheet and what formula is missing?.


You are receiving this mail because:
      You reported the bug.

Microlise Ltd | Farrington Way | Eastwood | Nottingham | NG16 3AG  (Registered Office) 
T: 01773 537000 | F: 01773 537373 |  enquiries@microlise.com  |  www.microlise.com   
Microlise Service Desk | Nottingham | UK 
T: 01773 537474 | E:  servicedesk@microlise.com   
This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please notify the sender and delete it immediately. Any disclosure, copying, distribution, or any action taken or omitted is to be taken in reliance on it is prohibited and may be unlawful. Please note any views or opinions presented in this email message are solely those of the author and do not necessarily represent those of the Microlise Group unless otherwise specifically stated.  

Microlise Group Limited - Registered in England and Wales No. 1670983 | Microlise Limited - Registered in England and Wales No. 3037936 | Microlise Engineering Limited - Registered in England and Wales No. 2211125 | VAT Number 694 5425 02 | Please think about the environment......Don't print this email unless you need to.
Comment 4 AVAGO 2013-04-19 07:08:22 UTC
Created attachment 78211 [details]
attachment-30074-1.dat
Comment 5 AVAGO 2013-04-19 07:08:22 UTC
Created attachment 78212 [details]
17576078.gif
Comment 6 AVAGO 2013-04-19 07:08:22 UTC
Created attachment 78213 [details]
17370477.gif
Comment 7 AVAGO 2013-04-19 07:08:22 UTC
Created attachment 78214 [details]
graycol.gif
Comment 8 AVAGO 2013-04-19 07:08:22 UTC
Created attachment 78215 [details]
pic14771.gif
Comment 9 AVAGO 2013-04-19 07:08:22 UTC
Created attachment 78216 [details]
ecblank.gif
Comment 10 AVAGO 2013-04-30 08:44:30 UTC
Hello
    Is there any update to this ? or have you been able to recreate the
problem ?

Regards

Phil
Support Engineer
Microlise Ltd
Telephone: 01773 537000
Direct: 01773 537345

phil.storey@microlise.com
http://www.microlise.com/

Please consider the environment before printing this e-mail

Microlise Ltd | Farrington Way | Eastwood | Nottingham | NG16 3AG  (Registered Office) 
T: 01773 537000 | F: 01773 537373 |  enquiries@microlise.com  |  www.microlise.com   

Microlise Service Desk | Nottingham | UK 
T: 01773 537474 | E:  servicedesk@microlise.com   

This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please notify the sender and delete it immediately. Any disclosure, copying, distribution, or any action taken or omitted is to be taken in reliance on it is prohibited and may be unlawful. Please note any views or opinions presented in this email message are solely those of the author and do not necessarily represent those of the Microlise Group unless otherwise specifically stated.  

Microlise Group Limited - Registered in England and Wales No. 1670983 | Microlise Limited - Registered in England and Wales No. 3037936 | Microlise Engineering Limited - Registered in England and Wales No. 2211125 | VAT Number 694 5425 02 | Please think about the environment......Don't print this email unless you need to.
Comment 11 m_a_riosv 2013-04-30 23:11:13 UTC
Hi AVAGO,

can you attach the file created with 3.6, to see if we can reproduce the issue.

Please and sorry but it is very annoying all that text after the comments, make difficult follow the answers.
Comment 12 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78694 [details]
attachment-31850-0.html

OK
   I will try to tidy it up

Unfortunately I only have a copy that is now in V4.01 but the same thing
will happen, If you have a fresh install of 4.01 the attached file should
open with graphs visible and should look like this








If you then upgrade to the latest version of LibreOffice 4.02 the graphs
etc are not there and looks like this





(See attached file: Production Plan 2013.ods)

I have also attached the file when it has been saved as a ms office
97/200/2003 and the graphs are still missing

(See attached file: Production Plan 2013.xls)
Regards

Phil
Support Engineer
Microlise Ltd
Telephone: 01773 537000
Direct: 01773 537345

phil.storey@microlise.com
http://www.microlise.com/

Please consider the environment before printing this e-mail

Microlise Ltd | Farrington Way | Eastwood | Nottingham | NG16 3AG  (Registered Office) 
T: 01773 537000 | F: 01773 537373 |  enquiries@microlise.com  |  www.microlise.com   

Microlise Service Desk | Nottingham | UK 
T: 01773 537474 | E:  servicedesk@microlise.com   

This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please notify the sender and delete it immediately. Any disclosure, copying, distribution, or any action taken or omitted is to be taken in reliance on it is prohibited and may be unlawful. Please note any views or opinions presented in this email message are solely those of the author and do not necessarily represent those of the Microlise Group unless otherwise specifically stated.  

Microlise Group Limited - Registered in England and Wales No. 1670983 | Microlise Limited - Registered in England and Wales No. 3037936 | Microlise Engineering Limited - Registered in England and Wales No. 2211125 | VAT Number 694 5425 02 | Please think about the environment......Don't print this email unless you need to.
Comment 13 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78695 [details]
attachment-31850-1.dat
Comment 14 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78696 [details]
14172234.gif
Comment 15 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78697 [details]
14050090.gif
Comment 16 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78698 [details]
14379698.gif
Comment 17 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78699 [details]
14875716.gif
Comment 18 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78700 [details]
attachment-31850-2.dat
Comment 19 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78701 [details]
Production Plan 2013.ods
Comment 20 AVAGO 2013-05-01 07:40:42 UTC
Created attachment 78702 [details]
Production Plan 2013.xls
Comment 21 m_a_riosv 2013-05-01 11:14:59 UTC
Created attachment 78713 [details]
Sample file recreated the chart.

Neither files show the chart, opening with one of the three following versions:
S.O. Win7x64 Ultimate
LO Version 3.6.6.1 (Build ID: a61ad19)
LO Version 4.0.3.1 (Build ID: a67943cd4d125208f4ea7fa29439551825cfb39)
LO Version: 4.1.0.0.alpha0 + Build ID: 4c4b9db8bbaed7acd064a4015fabe784c4fbca2 Tinderbox: Win-x86 @ 6, Branch: master, Time: 2013-04-28_06: 18:09

Recreating the chart with 3.6, it looks good on 4.0.3 or 4.1dev.

Have you tried resetting the user profile?, sometimes solve strange issues.
https://wiki.documentfoundation.org/UserProfile
Comment 22 AVAGO 2013-05-01 11:27:19 UTC
Created attachment 78714 [details]
attachment-5305-0.html

I have followed the instruction for resetting the profile, but still no
charts are showing, when is 4.0.3 released ?

Regards

Phil
Support Engineer
Microlise Ltd
Telephone: 01773 537000
Direct: 01773 537345

phil.storey@microlise.com
http://www.microlise.com/

Please consider the environment before printing this e-mail


                                                                           
             bugzilla-daemon@f                                             
             reedesktop.org                                                
                                                                        To 
             01/05/2013 12:14          phil.storey@microlise.com,          
                                                                        cc 
                                                                           
                                                                   Subject 
                                       [Bug 63671] Spredsheet Formula      
                                       missing after upgrade from 3.6 to   
                                       4.01 & 4.0.2.2                      
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           
                                                                           




Comment # 21 on bug 63671 from mariosv
Created attachment 78713 [details]
Sample file recreated the chart.

Neither files show the chart, opening with one of the three following
versions:
S.O. Win7x64 Ultimate
LO Version 3.6.6.1 (Build ID: a61ad19)
LO Version 4.0.3.1 (Build ID: a67943cd4d125208f4ea7fa29439551825cfb39)
LO Version: 4.1.0.0.alpha0 + Build ID:
4c4b9db8bbaed7acd064a4015fabe784c4fbca2
Tinderbox: Win-x86 @ 6, Branch: master, Time: 2013-04-28_06: 18:09

Recreating the chart with 3.6, it looks good on 4.0.3 or 4.1dev.

Have you tried resetting the user profile?, sometimes solve strange issues.
https://wiki.documentfoundation.org/UserProfile


You are receiving this mail because:
      You reported the bug.Microlise Ltd | Farrington Way | Eastwood | Nottingham | NG16 3AG  (Registered Office) 
T: 01773 537000 | F: 01773 537373 |  enquiries@microlise.com  |  www.microlise.com   
Microlise Service Desk | Nottingham | UK 
T: 01773 537474 | E:  servicedesk@microlise.com   
This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error please notify the sender and delete it immediately. Any disclosure, copying, distribution, or any action taken or omitted is to be taken in reliance on it is prohibited and may be unlawful. Please note any views or opinions presented in this email message are solely those of the author and do not necessarily represent those of the Microlise Group unless otherwise specifically stated.  

Microlise Group Limited - Registered in England and Wales No. 1670983 | Microlise Limited - Registered in England and Wales No. 3037936 | Microlise Engineering Limited - Registered in England and Wales No. 2211125 | VAT Number 694 5425 02 | Please think about the environment......Don't print this email unless you need to.
Comment 23 AVAGO 2013-05-01 11:27:19 UTC
Created attachment 78715 [details]
attachment-5305-1.dat
Comment 24 AVAGO 2013-05-01 11:27:19 UTC
Created attachment 78716 [details]
graycol.gif
Comment 25 AVAGO 2013-05-01 11:27:19 UTC
Created attachment 78717 [details]
pic03168.gif
Comment 26 AVAGO 2013-05-01 11:27:19 UTC
Created attachment 78718 [details]
ecblank.gif
Comment 27 ign_christian 2013-07-26 02:10:46 UTC
Hello AVAGO, 

Please don't reply from email. Replying via this bug page instead:
https://bugs.freedesktop.org/show_bug.cgi?id=63671

Have you tried LO 4.0.4.2? I suggest to do clean/fresh install (uninstall old version & reset user profile), & might give better result if you also do registry & disk cleaning.
Comment 28 retired 2013-11-21 08:15:46 UTC
Closing this issue for now. Important information is missing. No feedback for over 3 months now.

avago, if you still experience this problem, could you please try to:

* test against the latest stable LO version (currently 4.1.3.2)
http://libreoffice.org/download/

* also try following ign_christian’s suggestions.

Should you still run into this problem, you can re-open this issue.
Comment 29 retired 2013-11-21 08:16:12 UTC
Closing this issue for now. Important information is missing. No feedback for over 3 months now.

avago, if you still experience this problem, could you please try to:

* test against the latest stable LO version (currently 4.1.3.2)
http://libreoffice.org/download/

* also try following ign_christian’s suggestions.

Should you still run into this problem, you can re-open this issue.