|
|
Subject: Currency format in Excel report - msg#00007
List: java.jasperreports.general
Hi, is there any chance to set in report, Excel cell format to currency?
Thanks in advance.
--
View this message in context:
http://www.nabble.com/Currency-format-in-Excel-report-tf4668856.html#a13337263
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Was this page helpful?
Thread at a glance:
Previous Message by Date:
click to view message preview
Decimal Formating in Excel jasper report
While generating report , their is inconsistencies of how the quantity,
original cost, purchase price
We are sending data formatted manner only , but while rendering the data to
Excel format.
So different senarios are :
Instead of 333.00 its displaying 333
Instead of 333.99 its displaying 333.99
Instead of 3,333.00 its displaying 3,333.00
Can someone pls suggest me what to do ...?
--
View this message in context:
http://www.nabble.com/Decimal-Formating-in-Excel-jasper-report-tf4669469.html#a13338834
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Next Message by Date:
click to view message preview
Re: Decimal Formating in Excel jasper report
You can convert the number type double into a formatted string with this library: - java.text.DecimalFormat service formatSample:double numero = 12.5 new java.text.DecimalFormat("#,##0").format(numero) ---> 12
new java.text.DecimalFormat("#,##0.00").format(numero) ---> 12.50That's all.See you.pd: my english is a little, sorry about that2007/10/22, diptypatil <
diptypatil-/E1597aS9LQAvxtiuMwx3w@xxxxxxxxxxxxxxxx>:While generating report , their is inconsistencies of how the quantity,
original cost, purchase priceWe are sending data formatted manner only , but while rendering the data toExcel format.So different senarios are :Instead of 333.00 its displaying 333Instead of 333.99
its displaying 333.99Instead of 3,333.00 its displaying 3,333.00Can someone pls suggest me what to do ...?--View this message in context:
http://www.nabble.com/Decimal-Formating-in-Excel-jasper-report-tf4669469.html#a13338834Sent from the jasperreports-questions mailing list archive at Nabble.com.-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.Still grepping through log files to find problems? Stop.Now Search log events and configuration files using AJAX and a browser.Download your FREE copy of Splunk now >>
http://get.splunk.com/_______________________________________________jasperreports-questions mailing listjasperreports-questions-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/_______________________________________________
jasperreports-questions mailing list
jasperreports-questions-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
Previous Message by Thread:
click to view message preview
Decimal Formating in Excel jasper report
While generating report , their is inconsistencies of how the quantity,
original cost, purchase price
We are sending data formatted manner only , but while rendering the data to
Excel format.
So different senarios are :
Instead of 333.00 its displaying 333
Instead of 333.99 its displaying 333.99
Instead of 3,333.00 its displaying 3,333.00
Can someone pls suggest me what to do ...?
--
View this message in context:
http://www.nabble.com/Decimal-Formating-in-Excel-jasper-report-tf4669469.html#a13338834
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
Next Message by Thread:
click to view message preview
2 charts in one report from 2 db tables(ireport)
hi, i have a requirement where i need to display 2 charts(pie and bar)in a
single report side by side whose data come from different tables from the
database.how can i do this using jasperreports and ireport.any help would be
appreciated.....thanks in advance.
--
View this message in context:
http://www.nabble.com/2-charts-in-one-report-from-2-db-tables%28ireport%29-tf4698878.html#a13432434
Sent from the jasperreports-questions mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
|
|