Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
  #1 (permalink)  
Old 05-07-2008, 11:57 AM
Bill Brock Bill Brock is offline
Elite Member
 
Join Date: May 2007
Location: Oklahoma
ZCS Version: 5.0.6_GA_2313.openSUSE_10.2_20080522133539 openSUSE_10.2 FOSS
Posts: 366
Bill Brock is on a distinguished road
Default Document formatting goes away.

After entering a formula in a spreadsheet cell and formatting for 4 decimals it will revert back to two decimals at will.

Copying and pasting formulas doesn't work.

Documents was a main feature in my chosing Zimbra. E-mail software is a dime a dozen. It is these additional features that sets Zimbra apart. But they do not work properly.
Reply With Quote
  #2 (permalink)  
Old 05-07-2008, 02:37 PM
Bill Brock Bill Brock is offline
Elite Member
 
Join Date: May 2007
Location: Oklahoma
ZCS Version: 5.0.6_GA_2313.openSUSE_10.2_20080522133539 openSUSE_10.2 FOSS
Posts: 366
Bill Brock is on a distinguished road
Default

If any of the cells in the formula have a set number of decimal points then the cell wants to default to the number of decimal places the cell used in the formula has instead of the number of decimal places it was formatted to.

No spreadsheet I have ever used acts this way. This has to be a bug.

Does anyone out there use the documents feature in Zimbra that might have some input here?
Reply With Quote
  #3 (permalink)  
Old 05-08-2008, 09:08 AM
Bill Brock Bill Brock is offline
Elite Member
 
Join Date: May 2007
Location: Oklahoma
ZCS Version: 5.0.6_GA_2313.openSUSE_10.2_20080522133539 openSUSE_10.2 FOSS
Posts: 366
Bill Brock is on a distinguished road
Default

Nobody wants to chime in?

Is it something I said? :-)
Reply With Quote
  #4 (permalink)  
Old 05-08-2008, 11:56 AM
mmorse's Avatar
mmorse mmorse is online now
Zimbra Employee
 
Join Date: May 2006
Location: USA
ZCS Version: NE & OS - in the many flavors of 4.5 & 5.0
Posts: 4,302
mmorse is on a distinguished road
Send a message via AIM to mmorse Send a message via MSN to mmorse Send a message via Yahoo to mmorse Send a message via Skype™ to mmorse
Default

Quote:
Originally Posted by Bill Brock View Post
After entering a formula in a spreadsheet cell and formatting for 4 decimals it will revert back to two decimals at will.
I assume this has to be incorporated with your next statement right? (They're just not 'randomly' changing?)

Quote:
Originally Posted by Bill Brock View Post
If any of the cells in the formula have a set number of decimal points then the cell wants to default to the number of decimal places the cell used in the formula has instead of the number of decimal places it was formatted to.
Think I see what your saying, but what's your reference spreadsheet program?

MS Excel 07 12.0.6:
A1: typed 0.1234 displayed 0.1234
A1: typed 0.1234 displayed 0.1234 -hid 2 decimals so 0.12 was shown
A3: =SUM(A1:A2) displays 0.2468

OO Calc 2.4.0:
A1: typed 0.1234 displayed 0.12 -added 2 decimal places so 0.1234 was shown
A2: typed 0.1234 displayed 0.12 -left alone
A3: =SUM(A1:A2) displays 0.25

ZCS 5.0.5/.6:
A1: typed 0.1234 displayed 0.1234 -left auto
A2: typed 0.1234 displayed 0.1234 -set to 2 decimals so 0.12 was shown
A3: =SUM(A1:A2) displays 0.25 clicking cell shows mode is 2 decimals
-You have to manually select 'Auto' again or '4 decimals' before it shows 0.2468

More proof that it's using the largest manually selected:

ZCS 5.0.5/.6:
A1: typed 0.123456 displayed 0.123456 - left auto
A2: typed 0.123456 displayed 0.123456 -changed to 5 decimals so 0.12345 was shown
A3: typed 0.123456 displayed 0.123456 -changed to 4 decimals so 0.1234 was shown
A4: typed 0.123456 displayed 0.123456 -changed to 3 decimals so 0.123 was shown
A5: typed 0.123456 displayed 0.123456 -changed to 2 decimals so 0.12 was shown
A6: =SUM(A1:A5) displays 0.61728 clicking cell shows mode is 5 decimals

Almost the same thing again but left A2 alone:

ZCS 5.0.5/.6:
A1: typed 0.123456 displayed 0.123456 - left auto
A2: typed 0.123456 displayed 0.123456 - left auto
A3: typed 0.123456 displayed 0.123456 -changed to 4 decimals so 0.1234 was shown
A4: typed 0.123456 displayed 0.123456 -changed to 3 decimals so 0.123 was shown
A5: typed 0.123456 displayed 0.123456 -changed to 2 decimals so 0.12 was shown
A6: =SUM(A1:A5) displays 0.6173 clicking sell shows mode is 4 decimals

So you could file an RFE for: Use 'auto decimals' instead of reverting to largest manually selected decimal of other cells in formulas. But that's not a bug as far as I can tell, it's just a preferred usage case.

As the last above scenario is still contradictory to OO Calc 2.4.0:
A1: typed 0.123456 displayed 0.12 - left auto
A2: typed 0.123456 displayed 0.12 - left auto
A3: typed 0.123456 displayed 0.12 -changed to 4 decimals so 0.1235 was shown
A4: typed 0.123456 displayed 0.12 -changed to 3 decimals so 0.123 was shown
A5: typed 0.123456 displayed 0.12 -changed to 2 decimals so 0.12 was shown
A6: =SUM(A1:A5) displays 0.62 (seems OO likes 2 decimal places no matter the cell width)

And also still contradictory to MS Excel 07:
A1: typed 0.123456 displayed 0.123456 - left auto
A2: typed 0.123456 displayed 0.123456 - left auto
A3: typed 0.123456 displayed 0.123456 -changed to 4 decimals so 0.1235 was shown
A4: typed 0.123456 displayed 0.123456 -changed to 3 decimals so 0.123 was shown
A5: typed 0.123456 displayed 0.123456 -changed to 2 decimals so 0.12 was shown
A6: =SUM(A1:A5) displays 0.61728 (just logic - still stays at 5 after expanding cell width)
__________________
-Mike

We've released one of the coolest things ever!
5.0.7 is out in NE & FOSS!
Reply With Quote
  #5 (permalink)  
Old 05-08-2008, 01:33 PM
Bill Brock Bill Brock is offline
Elite Member
 
Join Date: May 2007
Location: Oklahoma
ZCS Version: 5.0.6_GA_2313.openSUSE_10.2_20080522133539 openSUSE_10.2 FOSS
Posts: 366
Bill Brock is on a distinguished road
Default

In your first example. I manually force 4 decimal places. Then I save the file. When I open it again to edit, the decimal places have gone back to two. It is the failure to keep the manual formatting that is bothering me.

I am actually dividing to dollar amounts and wanting 4 decimal precision in the answer. I format the numerator and denominator to two decimals and the cell with the formula to four decimal. All is well until I open the document a second time. Then the cell with the formula goes to 2 decimals even though I have selected or forced 4 decimals.

I'll post the exact cell content and formula and the formatting as soon as I get a second.

THANK YOU SOOOO Much for chiming in!!!!!
Reply With Quote
  #6 (permalink)  
Old 05-08-2008, 01:46 PM
mmorse's Avatar
mmorse mmorse is online now
Zimbra Employee
 
Join Date: May 2006
Location: USA
ZCS Version: NE & OS - in the many flavors of 4.5 & 5.0
Posts: 4,302
mmorse is on a distinguished road
Send a message via AIM to mmorse Send a message via MSN to mmorse Send a message via Yahoo to mmorse Send a message via Skype™ to mmorse
Default

Ah ha, you're right - see pics:

On save it's fine:


0.1234
0.12 (was set to 2)
0.2468 (had set it set it to 'auto' or '4 decimals' before save/close)

But upon editing after it reloads it's displayed as:


0.1234
0.12
0.25
__________________
-Mike

We've released one of the coolest things ever!
5.0.7 is out in NE & FOSS!
Reply With Quote
  #7 (permalink)  
Old 05-08-2008, 02:06 PM
Bill Brock Bill Brock is offline
Elite Member
 
Join Date: May 2007
Location: Oklahoma
ZCS Version: 5.0.6_GA_2313.openSUSE_10.2_20080522133539 openSUSE_10.2 FOSS
Posts: 366
Bill Brock is on a distinguished road
Default

What do we do. :-)

I've been using spreadsheets since Lotus 123 for DOS. I'm a CPA as well as an IT person and spreadsheets are second nature to me.

I'm glad you see where I was going. Is this a bug that needs to be filed?

This documents things is one of the coolest parts of ZCS. I have big plans for my company's use of the feature.
Reply With Quote
  #8 (permalink)  
Old 05-08-2008, 03:41 PM
mmorse's Avatar
mmorse mmorse is online now
Zimbra Employee
 
Join Date: May 2006
Location: USA
ZCS Version: NE & OS - in the many flavors of 4.5 & 5.0
Posts: 4,302
mmorse is on a distinguished road
Send a message via AIM to mmorse Send a message via MSN to mmorse Send a message via Yahoo to mmorse Send a message via Skype™ to mmorse
Default

Quote:
Originally Posted by Bill Brock View Post
I'm glad you see where I was going. Is this a bug that needs to be filed?
Yup, I'd say file it!
__________________
-Mike

We've released one of the coolest things ever!
5.0.7 is out in NE & FOSS!
Reply With Quote
  #9 (permalink)  
Old 05-08-2008, 05:51 PM
Bill Brock Bill Brock is offline
Elite Member
 
Join Date: May 2007
Location: Oklahoma
ZCS Version: 5.0.6_GA_2313.openSUSE_10.2_20080522133539 openSUSE_10.2 FOSS
Posts: 366
Bill Brock is on a distinguished road
Default

I'll file it.

This pretty much shoots down one of my major projects.

UPDATE: I tricked it. I created a cell with 1.0000 with 4 decimal places and the divided my formulas by this cell. This is not a fix but I think it will allow me to continue with my project.

Last edited by Bill Brock : 05-09-2008 at 08:21 AM. Reason: Appended with some good news.
Reply With Quote
  #10 (permalink)  
Old 05-09-2008, 04:28 AM
Bill Brock Bill Brock is offline
Elite Member
 
Join Date: May 2007
Location: Oklahoma
ZCS Version: 5.0.6_GA_2313.openSUSE_10.2_20080522133539 openSUSE_10.2 FOSS
Posts: 366
Bill Brock is on a distinguished road
Default

This may be fodder for another post but it is another document issue.

a1: 5.51% percentage, auto decimal
a2: 6.68% percentage, auto dec.
a3: 7.54% percentage, auto dec.
a4: 19.72999999999... sum a1,a2,a3, percentage, auto decimal

a4 should be 19.73% instead of the 19.729999999... If I force 2 decimals it rounds up to the right answer so I wasn't that concerned. But this is straight addition and the sum is wrong.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving as draft still loses formatting in 5.0.2 GCNS Administrators 3 04-23-2008 03:58 PM
Cannot view global domain document lilwong Installation 5 11-19-2007 12:56 AM
Problems with Wiki / Documents on OSX/PPC GadgetGuru Installation 5 11-30-2006 08:03 AM
Document Provisioning error jawad@cogilent.com Administrators 1 11-19-2006 11:52 PM
upgrade 3.01>4.0.2@userlimit= backups "unknown document: BackupRequest" martin@coherentlogix.com Installation 6 10-04-2006 08:41 AM


freshmeat.net sourceforge.net The best Java IDE



 

Search Engine Optimization by vBSEO 3.0.0