Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Document formatting goes away.

Hybrid View

  1. #1
    Join Date
    May 2007
    Location
    Oklahoma
    Posts
    703
    Rep Power
    9

    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.

  2. #2
    Join Date
    May 2007
    Location
    Oklahoma
    Posts
    703
    Rep Power
    9

    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?

  3. #3
    Join Date
    May 2007
    Location
    Oklahoma
    Posts
    703
    Rep Power
    9

    Default

    Nobody wants to chime in?

    Is it something I said? :-)

  4. #4
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

    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)

  5. #5
    Join Date
    May 2007
    Location
    Oklahoma
    Posts
    703
    Rep Power
    9

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

  6. #6
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

    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

  7. #7
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    21

    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!

  8. #8
    Join Date
    May 2007
    Location
    Oklahoma
    Posts
    703
    Rep Power
    9

    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.

  9. #9
    Join Date
    May 2007
    Location
    Oklahoma
    Posts
    703
    Rep Power
    9

    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.

  10. #10
    Join Date
    May 2007
    Location
    Oklahoma
    Posts
    703
    Rep Power
    9

    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.

Similar Threads

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •