Tab101User
Lurker
Can anyone confirm this:
Open MS Excel (tested with Excel 2007) and create a new spreadsheet. Click one (or all) cell and set the cell number format to Accounting, 2 decimal places, symbol "$". Save the spreadsheet and export it to your Samsung Galaxy Tab II 10.1 device (or any other running Polaris Office).
Open the sheet in Polaris Office. Select the cell(s) and tap the Wrench icon and then the Numbers tab. "Currency" is highlighted (good). Tap "Currency". Decimal places is set to 2 (good) but Symbol is set to ₩ (bad).
Enter some numbers into the cell(s). They display with the $ symbol (example: $ 123.00).
Save the spreadsheet and export it back to your PC. Open in MS Excel; the numbers are displayed as ₩ 123.00. Right-click the cell and select format. The category is "Custom" and the format string is "_("₩"* #,##0.00_);_("₩"* (#,##0.00);_("₩"* "-"??_);_(@_)".
Can anyone confirm?
Samsung Galaxy Tab II 10.1 (Model GT-P5113
Android OS v4.0.4
Polaris Office 4.0 Build 4.0.5001.51-FV03
Open MS Excel (tested with Excel 2007) and create a new spreadsheet. Click one (or all) cell and set the cell number format to Accounting, 2 decimal places, symbol "$". Save the spreadsheet and export it to your Samsung Galaxy Tab II 10.1 device (or any other running Polaris Office).
Open the sheet in Polaris Office. Select the cell(s) and tap the Wrench icon and then the Numbers tab. "Currency" is highlighted (good). Tap "Currency". Decimal places is set to 2 (good) but Symbol is set to ₩ (bad).
Enter some numbers into the cell(s). They display with the $ symbol (example: $ 123.00).
Save the spreadsheet and export it back to your PC. Open in MS Excel; the numbers are displayed as ₩ 123.00. Right-click the cell and select format. The category is "Custom" and the format string is "_("₩"* #,##0.00_);_("₩"* (#,##0.00);_("₩"* "-"??_);_(@_)".
Can anyone confirm?
Samsung Galaxy Tab II 10.1 (Model GT-P5113
Android OS v4.0.4
Polaris Office 4.0 Build 4.0.5001.51-FV03