Bug 61969 - Negative formula totals not staying red on spreadsheet file re-open
Summary: Negative formula totals not staying red on spreadsheet file re-open
Status: RESOLVED DUPLICATE of bug 60215
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: Other Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-03-07 15:43 UTC by rita_bee
Modified: 2013-04-19 09:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file - B2:B4 should be red (7.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-03-08 17:12 UTC, crazyskeggy
Details

Note You need to log in before you can comment on or make changes to this bug.
Description rita_bee 2013-03-07 15:43:46 UTC
Version4.0Ink

Problem is when a totals cell is set up to display an answer as a minus figure shown in red it only stays red at initial calculation and print out but once the file has been saved, exited and re-opened it displays coloured black.

Hope you can sort this guys as I can not live with having to keep altering files each time I want to re-open them.
Comment 1 crazyskeggy 2013-03-07 19:38:53 UTC
Thanks for reporting this to us! If you can, please answer the following questions:

1. Does "Version4.0Ink" mean that you are running LibreOffice version 4.0?
2. Which part of LibreOffice are you using? Writer, Calc, Math, Draw or Base?
3. Can you attach a sample file where this is broken on?
Comment 2 crazyskeggy 2013-03-07 19:42:32 UTC
Sorry - ignore no. 2 as I didn't read your summary.
Comment 3 rita_bee 2013-03-08 16:23:49 UTC
1. Yes it's version 4.0
2. Spreadsheet
3. Best to try inputting 2 negative numbers in a spreadsheet yourselves and getting the system to total them as a minus figure shown in red. It will display properly in red but not when you close the file and reload it.
 

________________________________
 From: "bugzilla-daemon@freedesktop.org" <bugzilla-daemon@freedesktop.org>
To: rita_bee@yahoo.com 
Sent: Thursday, March 7, 2013 7:38 PM
Subject: [Bug 61969] Negative formula totals not staying red on spreadsheet file re-open
   
 
crazyskeggy@gmail.com  changed bug 61969  
What 
Removed 
Added  
Status  UNCONFIRMED   NEEDINFO    
Ever confirmed      1    
Comment # 1 on bug 61969 from crazyskeggy@gmail.com  
Thanks for reporting this to us! If you can, please answer the following
questions: 1. Does "Version4.0Ink" mean that you are running LibreOffice version 4.0?
2. Which part of LibreOffice are you using? Writer, Calc, Math, Draw or Base?
3. Can you attach a sample file where this is broken on?  

________________________________
 You are receiving this mail because: 
	* You reported the bug.
Comment 4 crazyskeggy 2013-03-08 17:12:02 UTC
Created attachment 76172 [details]
Example file - B2:B4 should be red

I can reproduce this bug on Windows XP SP3 with LibO 4.0.0.3.

I am attaching a sample file to make it easier for devs to understand the problem. I have set B4 to number with Negative numbers in red (like B2:B3) but when you open the file it shows up black.
Comment 5 bz.libreoffice.org 2013-04-09 05:54:29 UTC
The behavior remains flaky throughout 4.0.1.2 / 4.0.2 as well on Windows 8 as on OSX (Java is great!)

Could also reproduce with the above attachment, so I'm not attaching my large table.
Comment 6 Owen Genat (retired) 2013-04-17 02:31:46 UTC
Marking as duplicate as a result of https://bugs.freedesktop.org/show_bug.cgi?id=60215#c12.

*** This bug has been marked as a duplicate of bug 60215 ***
Comment 7 rita_bee 2013-04-19 09:49:06 UTC
Hi there
            I have reported this bug again as it still exists on the updated version 4.0.2 that I have installed today. The totals in the spread sheet can initially show in red, be saved and the file exited but the file continues to reload the totals in black. Regrettably I am having to use Microsoft software to do spread sheet calculations until you can sort this out.
 
Regards
 
Rita

----- Forwarded Message -----
From: Rita Bee <rita_bee@yahoo.com>
To: "bugzilla-daemon@freedesktop.org" <bugzilla-daemon@freedesktop.org> 
Sent: Friday, March 8, 2013 4:23 PM
Subject: Re: [Bug 61969] Negative formula totals not staying red on spreadsheet file re-open

1. Yes it's version 4.0
2. Spreadsheet
3. Best to try inputting 2 negative numbers in a spreadsheet yourselves and getting the system to total them as a minus figure shown in red. It will display properly in red but not when you close the file and reload it.

From: "bugzilla-daemon@freedesktop.org" <bugzilla-daemon@freedesktop.org>
To: rita_bee@yahoo.com 
Sent: Thursday, March 7, 2013 7:38 PM
Subject: [Bug 61969] Negative formula totals not staying red on spreadsheet file re-open

crazyskeggy@gmail.com changed bug 61969 
What
Removed
Added
Status UNCONFIRMED  NEEDINFO  
Ever confirmed    1  
Comment # 1 on bug 61969 from crazyskeggy@gmail.com 
Thanks for reporting this to us! If you can, please answer the following
questions:

1. Does "Version4.0Ink" mean that you are running LibreOffice version 4.0?
2. Which part of LibreOffice are you using? Writer, Calc, Math, Draw or Base?
3. Can you attach a sample file where this is broken on?You are receiving this mail because: 
	* You reported the bug.