[Libreoffice-bugs] [Bug 118638] New: subtotal option loses doesn't contain existing format for column

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118638

            Bug ID: 118638
           Summary: subtotal option loses doesn't contain existing format
                    for column
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: consult.result at gmail.com

Description:
I was analyzing some financial information. One column contained $ amounts. I
elected to create subtotals grouped by data in another column. Each subtotal
created was not a $ amount it was simply a number with a 1 to 5 digit decimal.

Steps to Reproduce:
1.create subtotal
2.
3.

Actual Results:
no $ and unspecified decimal precision

Expected Results:
should be a $ amount. (I assume the problem exists for all possible cell
formats in that it appears existing cell format in no applied.


Reproducible: Always


User Profile Reset: No



Additional Info:
(Partial sample to save space) I will attach the entire file.

06/25/18 01:39 AM       $24.80  5408
06/27/18 09:59 AM       $15.91  5408
        18.5978333333333        5408 Average
04/07/17 08:24 AM       $25.84  5423
05/09/17 07:26 AM       $20.35  5423
06/15/17 12:29 PM       $11.65  5423
08/25/17 09:37 AM       $23.86  5423
08/26/17 04:20 AM       $5.55   5423
09/22/17 04:08 AM       $12.65  5423
        16.65   5423 Average
12/06/17 08:33 AM       $29.04  5433
02/10/18 06:06 AM       $31.24  5433
        30.14   5433 Average
04/13/17 03:15 AM       $23.36  5436
06/06/17 07:26 AM       $27.53  5436
12/20/17 07:28 AM       $2.59   5436
03/14/18 02:37 AM       $30.86  5436
        21.085  5436 Average
01/04/17 05:57 AM       $26.40  5445

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180709/d46f33f3/attachment.html>