https://bz.apache.org/ooo/show_bug.cgi?id=123831
--- Comment #4 from Bruce Roosa <sf3...@gmail.com> --- When .csv file is opened as .odf file single quote is present and the only way to correct is to enter each cell and physically remove the Single quote. However - The problem does not show when the page is copied and pasted. For instance; Line 2, on the spreadsheet shows [$'-69.27]. 07/30/2015 $-1534.12 PAYMENT - THANK YOU 1 08/03/2015 $-69.27 HARBOR FREIGHT TOOLS 6 WACO TX 2 07/16/2015 $7.99 SUBWAY 00323550 GOLDTHWAITE TX 2 07/16/2015 $8.82 SUBWAY 00108829 WACO TX 2 07/17/2015 $80.98 INKJETSUPERSTORE.COM LOS ANGELES CA 2 07/17/2015 $375.00 STRICTLYTOOLBOXES.COM 08882891952 FL 2 07/20/2015 $29.41 PATS SMALL ENGINE PLUS 07634131344 MN 2 07/21/2015 $21.64 GREENLIFE NURSERY INC WACO TX 2 07/21/2015 $10.99 SUBWAY 00108829 WACO TX 2 07/23/2015 $179.95 AMAZON MKTPLACE PMTS AMZN.COM/BILL WA 2 07/24/2015 $17.74 THE HOME DEPOT 6532 WACO TX 2 07/26/2015 $51.21 Amazon.com AMZN.COM/BILL WA 2 07/28/2015 $24.00 AMAZON MKTPLACE PMTS AMZN.COM/BILL WA 2 07/28/2015 $51.88 Amazon.com AMZN.COM/BILL WA 2 07/31/2015 $81.54 WAL-MART #5389 WOODWAY TX 2 07/31/2015 $7.25 SUBWAY 00108829 WACO TX 2 07/31/2015 $11.98 AVANGATE*GLARYSOFT.COM 8003194433 CA 2 08/01/2015 $10.23 SUBWAY 00108829 WACO TX 2 08/01/2015 $12.98 DRI*GLARY UTILITIES PR MINNETONKA MN 2 08/01/2015 $78.13 HARBOR FREIGHT TOOLS 6 WACO TX 2 08/02/2015 $5.00 HEB #583 WACO TX 2 08/02/2015 $109.58 AMAZON MKTPLACE PMTS AMZN.COM/BILL WA 2 08/03/2015 $14.61 SOUPER SALAD #03 WACO TX 2 08/06/2015 $7.58 SUBWAY 00317198 BANGS TX 2 08/07/2015 $3.12 HEB #583 WACO TX 2 08/11/2015 $12.99 ALTEX ELECTRONICS LTD WACO TX 2 08/11/2015 $60.95 HARBOR FREIGHT TOOLS 6 WACO TX 2 08/13/2015 $8.61 SUBWAY 00108829 WACO TX 2 -- You are receiving this mail because: You are on the CC list for the issue. You are the assignee for the issue.