Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: ODF 1.2 Part 2 CD 3
    • Component/s: OpenFormula
    • Labels:
      None
    • Proposal:
      Hide

      In summary of function add "(l'amortissement linéaire comptable)" after "using linear depreciation".

      In Semantics, replace "The period if interest" with "which period the depreciation should be calculated for"

      Replace "The type of day-count basis to use" with "Indicates the day count basis to use;"

      The text describing the formulas is also confusion. We currently say "For the first period in the life time...". That should really say, "When period = 0...", since the first period is 0, not 1.

      Then we should say, "For full periods, where period >0, the depreciation is cost*rate" (we have that formula)

      Then we should say, "For the last period, possibly a partial period, the depreciation = cost-salvage-accumulated-depreciation, where accumulated-depreciation is the sum of the depreciation in period 0 plus any full period depreciations.

      Also, "When period > depreciated life of the asset, i.e., when period > (cost-salvage)/(cost*rate) then the depreciation is 0."

      And finally, "Note: The behavior of this function is implementation-defined in cases where purchaseDate = firstPeriodEndDate "

      [Rob's note, this reflects current discrepancy between Excel and OpenOffice. If we can resolve that we can remove the implementation-defined note. But I think we need to find a French accountant first".

      Show
      In summary of function add "(l'amortissement linéaire comptable)" after "using linear depreciation". In Semantics, replace "The period if interest" with "which period the depreciation should be calculated for" Replace "The type of day-count basis to use" with "Indicates the day count basis to use;" The text describing the formulas is also confusion. We currently say "For the first period in the life time...". That should really say, "When period = 0...", since the first period is 0, not 1. Then we should say, "For full periods, where period >0, the depreciation is cost*rate" (we have that formula) Then we should say, "For the last period, possibly a partial period, the depreciation = cost-salvage-accumulated-depreciation, where accumulated-depreciation is the sum of the depreciation in period 0 plus any full period depreciations. Also, "When period > depreciated life of the asset, i.e., when period > (cost-salvage)/(cost*rate) then the depreciation is 0." And finally, "Note: The behavior of this function is implementation-defined in cases where purchaseDate = firstPeriodEndDate " [Rob's note, this reflects current discrepancy between Excel and OpenOffice. If we can resolve that we can remove the implementation-defined note. But I think we need to find a French accountant first".

      Description

      Copied from office-comment list

      Original author: "David King" <openoffice@drking.plus.com>
      Original date: 1 Sep 2008 20:27:21 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200809/msg00000.html

        Attachments

          Activity

            People

            • Assignee:
              rcweir Robert Weir (Inactive)
              Reporter:
              rcweir Robert Weir (Inactive)
            • Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: