Document formatting goes away.

[Bill Brock]

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.

[Bill Brock]

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?

[Bill Brock]

Nobody wants to chime in?

Is it something I said? :-)

[mmorse]

Originally Posted by Bill Brock

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?)

Originally Posted by Bill Brock

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)

[Bill Brock]

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!!!!!

[mmorse]

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

[Bill Brock]

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.

[mmorse]

Originally Posted by Bill Brock

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

Yup, I'd say file it!

[Bill Brock]

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.

[Bill Brock]

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.