Benjamin Samuel

Consider a webapp that has been pre-authenticated by an external system, and the authenticated user id is send via request headers. A UserService is invoked to load a custom UserDetails object from the app database. Want to know if the UserService will be invoked every time a request hits the application or only when SecurityContext doesn't have an Authentication object. Won't it be a performance hit if the UserService is called every time the request is passed via filters.

Say a form has a set of fields.
<form action="myAction.do"> <!--Set of fields to be duplicated: Begin--> <input type="text" name="myTextBox"/> <input type="radio" name="myRadioGroup"/> <input type="radio" name="myRadioGroup"/> <!--Set of fields to be duplicated: End--> </form>
I have an 'Add' button that duplicates the set of fields and 'Delete' button that deletes a chosen section. Add and delete functionality is done via jquery() clone and remove() methods. While i clone, obviously the cloned section will have the same radio button name and hence it will become the part of the first radio group. What i wanted is a new set of radio button group. For this I can manipulate the name of the radio button by appending an index. What I wanted to know is how should we handle these multiple radio button group in the ActionForm.

Thanks in advance

Jeanne,

Could you please elaborate on this? Could you provide me a sample code if possible?
Depending on the property i want to color the cell.

Thank you.

Hi,

I want to know how to apply styles to the rows of a generated spreadsheet, based on a particular condition.

The scenario is like this:

I have a jsp, jsp1 which displays a report. This jsp contains an 'export to excel' button, on click of which, another jsp, jsp2 is displayed with the report data rendered as an xml. Certain rows of the report is coloured, based on the property 'agingColor' of the report bean, reportLineItemBean.

I need to colour the rows of my generated excel sheet also in a similar way. But i was unable to do the same as i could specify only one interior(background) colour in a particular style. The code is as follows:

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:html="http://www.w3.org/TR/REC-html40"> <Styles> <Style ss:ID="s23"> <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/> <Font /> <Interior ss:Color="#000000" ss:Pattern="Solid"/> </Style> </Styles> <Worksheet ss:Name="ReportScreenExcel"> <table> <logic:notEmpty name="reportLineItemsBean" property="lineItems"> <logic:iterate id="lineItems" name="reportLineItemsBean" property="lineItems"> <Row ss:AutoFitHeight="0" ss:Height="25"> <Cell ss:StyleID="s23"><Data ss:Type="String"> <bean:write name="lineItems" property="agingColor"/> <bean:write name="lineItems" property="creName"/></Data> </Cell> <Cell ss:StyleID="s23"><Data ss:Type="String"> <bean:write name="lineItems" property="agingColor"/> <bean:write name="lineItems" property="clientName"/></Data> </Cell> </Row> </logic:iterate> </logic:notEmpty> <table> </Worksheet> </Workbook>

The above code displays the hexadecimal value of the agingColor along with the cell value, rather than applying that color to the styles. I need to apply the values for the background color for the cells as specified by the agingColor property, in a similar way the color #000000 is applied to the cells.

Please help.
Thanks in advance.

Thanks Himanshu. I tried with HSSFRichTextString and the code is given below:

HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet1 = wb.createSheet("A"); HSSFRow row = sheet1.createRow(1); // Create a cell and put a value in it. HSSFCell cell = row.createCell((short) 0); cell.setCellValue(1); // Another way to write to a cell. row.createCell((short) 1).setCellValue(new HSSFRichTextString("000005544")); row.createCell((short) 2).setCellValue(new HSSFRichTextString("test")); row.createCell((short) 3).setCellValue(new HSSFRichTextString("'000005544")); // Write the output to a file FileOutputStream fileOut = new FileOutputStream("mysampleworkbook.xls"); wb.write(fileOut); fileOut.close();


Couldnt attach the generated xls.

The second cell displays 000005544 and when i navigate to this cell and double click on it and come out of it, the leading zeros are lost.
The fourth cell displays '000005544 and when i double click on this one, the apostrophe is gone and the leading zeros are retained.

The problem is: The user is going to copy the values from the xls i have generated. While copying only the number is expected to be copied. The user may/may not double click on the cells in the xls generated. How can I achieve this? please help.

Thanks

Rob, Thank you for your time.

I tried with an apostrophe before the number with leading zeros. But when i open the xls it shows the cell value as '00012345. If i double click on the cell, then the value is displayed without a '

What could be the workaround for this?

From the xls that i generate programatically, the user needs to copy the value to another application. And the above scenario will copy the text along with the apostrophe(') sign.

Hi,

I want to preserve leading zeros while exporting the data into an xls using Apache POI. If I set the data type to text, the leading zeros are getting removed on double clicking the in cell. Below is how i set the value:
row.createCell((short)1).setCellValue("00012345");

please help. How can this be achieved via POI?

Thanks

I 'm pretty sure that you're not creating an XLS file, but rather some text file that you're trying to have Excel open by setting the content type; is that correct?

Yes, thats exactly what i have done. I am not creating a binary file and data writing into it.
I tried to display the field as a formula field[by prefixing and'=' sign], and tried appending a space [ ] to convert it to string format. But this is not how they want it to be done. please let me know if you are aware of any other workaround.

Hi,

I have a jsp which i am rendering as an xls. I need to convert the numbers as text format.

for example: If i have a number as 00010345 it should be displayed as is when exported to an xls. Currently the number is displayed as, 10345 (Without the zeros)

Hope it was descriptive enough. Please help.

My actual problem is little more complicated than this

So is it not possible to do the Criteria check on 'age' field?

Consider the following bean class:

class Person{ private int id; private String name; private long yearOfBirth; private int age; public void setYearOfBirth(long yob){ yearOfBirth = yob; this.setAge(2009-yob); } //: //: /*for brevity, not including other getter and settter methods*/ }

Assume the hbm file have the mapping for the first 3 fields viz. id, name and yearOfBirth. Field 'age' is calculated based on the yearOfBirth and is set via setYearOfBirth() (Age is not stored in DB). I need a solution using Criteria API (org.hibernate.Criteria) to search on Person objects based on 'age' field. I'm trying the below code; but it raises an exception: org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException (could not resolve property: age of: Person)
Criteria crit = session.createCriteria(Person.class).add(Expression.eq("age",15));

Any solutions ?

Thanks,
Binil

Got it!
Thanks for the explanation

But how is that the anonymous class extends HashMap even without specifying the 'extends' keyword.

Hi,

I just came across this code below. I'm not clear how this works. Can you please explain me how this works?

public static final HashMap hm = new HashMap(){ { put("key1","value1"); put("key2","value2"); } };

I'm not understanding how this put() is working normally.

Thanks in advance
Binil

I'm having a double value
e.g. a)99558669546.
b)0.00125

I have to convert these values into String. I need to read the value as-is without any truncation or formatting. For E.g. i do not want 'a'
to be formatted in Exponential format (like E9) and i dont want 'b' to be truncated to 0.001 while converting to String.

How can I achieve this using NumberFormat class or is there any other class through which this can be achieved?