Accounting Format Fail

Posted by: kbj on 27 January 2020, 3:16 am EST

  • Posted 27 January 2020, 3:16 am EST

    Decimal points do not line up when using the "Accounting" format.
  • Replied 27 January 2020, 10:10 pm EST

    Hello Kingman,

    As I have seen in the image, the decimal point is not line up because of the extra bracket in the second cell which I consider the design behavior.
    Request to please explain if my understanding is wrong.

    Thanks,
    Mohit
  • Replied 28 January 2020, 1:17 am EST

    Hi Mohit,
    In Excel, the accounting format line up positive and negative decimal points:


    Please note the definition of the Accounting format in the Spread Designer Format Cells dialog:
  • Replied 28 January 2020, 9:07 pm EST

    Hello,

    Thanks for the detail information.
    I am able to reproduce the issue at my end. I have escalated the issue to our development team (SPNET-2473)and will inform you once I get any information from them.

    Thanks,
    Mohit
  • Replied 11 February 2020, 12:06 am EST

    Any Info?
  • Replied 12 February 2020, 10:38 pm EST

    Hello,

    As per dev, It's known issue of Spread.Win. Because of limited support from GDI+ and GDI32, we don't support painting space with other character width yet.

    Thanks,
    Mohit
  • Replied 13 February 2020, 7:38 am EST

    . . .which doesn't mean anything.
    All the developers have to do is measure the width of the ")" character and move the right justified positive value that much to the left. I do this with an overridden PaintCell sub.
    It seems the accounting format should work as described, or don't bother including it.
    -Kingman
  • Replied 17 February 2020, 4:48 pm EST

    Hello,

    I have forward this to our development team and will inform you once I get any reply from them.

    Thanks,
    Mohit
  • Replied 18 February 2020, 8:04 pm EST

    Hello,

    As per the developer, supporting the parentheses symbol is not just about translating the location. "(" can appear anywhere, inside the text. In addition, they have to care about other settings like orientation, wrap text.

    I have opened a feature request for the same and will inform you once I got any information from them.

    Thanks,
    Mohit
  • Replied 19 February 2020, 1:45 am EST

    Hi Mohit,
    The Accounting format is used exclusively for numbers, typically currency values. There never will be any text wrapping and the "(" is always to the left of the number and the ")" is always to the right of the value. Horizontal alignment only affects the currency symbol, the value is always right justified. Orientation can handled with some fairly simple trigonometry. A feature request shouldn't be required for an existing specification. They just need to make it work.
    -Kingman
  • Replied 24 February 2020, 8:56 pm EST

    Hello,

    Sorry for the delay!

    I have forward this to our development team and will inform you once I get any reply from them.

    Thanks,
    Mohit
  • Replied 24 February 2020, 9:56 pm EST

    Hello,

    Sorry for the inconvenience caused to you. As per the development team, it is our limitation for our text layout. We will try to support in the future releases.

    Thanks,
    Mohit
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels