Le 04/05/2012 19:19, gammoudi neji a écrit :
Hello, Thank you for your response ! I have attached the ods file.
Hi, It does work with your example, you can see there's plenty of cells with more than one line final Sheet sheet = SpreadSheet.createFromFile(new File("exemple.ods")).getSheet(2); // Iterating through each row of the selected sheet for (int nRowIndex = 5; nRowIndex < 20; nRowIndex++) { for (int nColIndex = 0; nColIndex < 11; nColIndex++) { final MutableCell cell = sheet.getCellAt(nColIndex, nRowIndex); System.out.println("aaaaaaaaa" + cell.getValue()); } } aaaaaaaaaCase No aaaaaaaaaRelated Function aaaaaaaaaCase ID aaaaaaaaaPath aaaaaaaaaCase Description aaaaaaaaaStep Description aaaaaaaaaSteps to produce aaaaaaaaaExpected Output aaaaaaaaaPriority aaaaaaaaaAffect aaaaaaaaa aaaaaaaaa1 aaaaaaaaaFNC_ECMS_WKF_PUB_01 aaaaaaaaa1 aaaaaaaaaContent Management \ Business Process Center \ Publishing Process\View aaaaaaaaaCreate document in Validation Requests Documents Center Drive aaaaaaaaaStep 1: Select Validation Requests Documents Center Drive aaaaaaaaa- Log in system - Go to Content Management, select File Explorer - Select “Validation Requests Documents Center Drive” aaaaaaaaa- User logs in system successfully - Move to Current drive : Validation Requests Documents Center aaaaaaaaaHigh aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaaFNC_ECMS_WKF_PUB_01 aaaaaaaaa1 aaaaaaaaaContent Management \ Business Process Center \ Publishing Process\View aaaaaaaaaCreate document in Validation Requests Documents Center Drive aaaaaaaaaStep 2: Create new documents aaaaaaaaa- Select Action tab - Create new document or upload file aaaaaaaaa- Create document or upload file successfully - This document has sent to validator for validation aaaaaaaaaHigh aaaaaaaaa aaaaaaaaa aaaaaaaaa2 aaaaaaaaaFNC_ECMS_WKF_PUB_01 aaaaaaaaa2 aaaaaaaaaContent Management \ Business Process Center \ Publishing Process\View aaaaaaaaaCheck assign task aaaaaaaaaStep 1: Create node (document or upload file) in Validation Requests Documents Center drive aaaaaaaaaCreate document or upload file in Validation Requests Documents Center drive aaaaaaaaa- Create document or upload file successfully - A request has sent to validator in Business Process Center aaaaaaaaaHigh aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaaFNC_ECMS_WKF_PUB_01 aaaaaaaaa2 aaaaaaaaaContent Management \ Business Process Center \ Publishing Process\View aaaaaaaaaCheck assign task aaaaaaaaaStep 2: Check assigned task aaaaaaaaa- Login by user is in validator:/platform/administrators - Go to Content Management, select Business Process Center - Select 'Task Controller' tab aaaaaaaaaAll assigned tasks are displayed aaaaaaaaaHigh aaaaaaaaa aaaaaaaaa aaaaaaaaa3 aaaaaaaaaFNC_ECMS_WKF_PUB_01 aaaaaaaaa3 aaaaaaaaaContent Management \ Business Process Center \ Publishing Process\View aaaaaaaaaView content of assigned task aaaaaaaaaStep 1: Create node (document or upload file) in Validation Requests Documents Center drive aaaaaaaaaCreate document or upload file in Validation Requests Documents Center drive aaaaaaaaa- Create document or upload file successfully - A request has sent to validator in Business Process Center aaaaaaaaaHigh aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaaFNC_ECMS_WKF_PUB_01 aaaaaaaaa3 aaaaaaaaaContent Management \ Business Process Center \ Publishing Process\View aaaaaaaaaView content of assigned task aaaaaaaaaStep 2: Show form to manage task aaaaaaaaa- Login by user is in validator:/platform/administrators - Go to Business Process Center - Select 'Task controller' tab - Click 'manage' on a evaluation task of content validation process aaaaaaaaa- 'Task manager' form appears aaaaaaaaaHigh aaaaaaaaa aaaaaaaaa aaaaaaaaa aaaaaaaaaFNC_ECMS_WKF_PUB_01 aaaaaaaaa3 aaaaaaaaaContent Management \ Business Process Center \ Publishing Process\View aaaaaaaaaView content of assigned task aaaaaaaaaStep 3: View content of assigned task aaaaaaaaa- Select 'View content' tab aaaaaaaaaThe content of task is shown aaaaaaaaaHigh aaaaaaaaa aaaaaaaaa