It will be nice to have this example. For me it was a special request from
the client and I had to find solutions. Tell me where to post the code with
comments and I will make time for this.
Cristian
MSB wrote:
>
> Thank you for this, really good piece of work and I was wondering if you
> would be willing to post it as an example on the POI website so that
> others can see how to perform this operation? If you do not have the time,
> I would be quite willing to work it up into an example and post the code
> here before submitting it to the website; and it goes without saying that
> you would be credited as the author.
>
> Yours
>
> Mark B
>
>
> MerlinCristi wrote:
>>
>> Update
>>
>> After some time I found the solution. And it is like this
>>
>> XSSFWorkbook wb = new XSSFWorkbook();
>> XSSFSheet s = wb.createSheet("Sheet1");
>> XSSFRow r;
>> XSSFCell c;
>> CTRowImpl ctr;
>> r = s.createRow( 0);
>> c = r.createCell( 0);
>> c.setCellStyle( timeblockLabel);
>> c.setCellValue( "Some Text");
>>
>> c = r.createCell( 1);
>> c.setCellStyle( timeblockLabel);
>>
>> c = r.createCell( 2);
>> c.setCellStyle( timeblockLabel);
>>
>> ctr = (CTRowImpl) r.getCTRow();
>> List spans = new ArrayList();
>> Object o = "1:3";
>> spans.add( o);
>> ctr.setSpans( spans);
>>
>> String filename = "workbook1.xlsx";
>> FileOutputStream out = new FileOutputStream(filename);
>> wb.write(out);
>> out.close();
>>
>> and
>>
>> timeblockLabel.setAlignment( XSSFCellStyle.ALIGN_CENTER_SELECTION);
>>
>> I tested and it works fine. The label is centered over selection.
>> If you decide to span something over cell 1,2,3 for example cell 1, 2, 3
>> must exist.
>>
>> Enjoy,
>> Cristian
>>
>>
>> MerlinCristi wrote:
>>>
>>> Hi. I made one xlsx file with some cells selected and saved. After that
>>> I loded with poi and
>>> if you call this code
>>>
>>> InputStream myxls = new FileInputStream("ex1.xlsx");
>>> XSSFWorkbook wb = new XSSFWorkbook(myxls);
>>> XSSFSheet s = wb.getSheetAt( 0);
>>> XSSFRow r = s.getRow(0);
>>> CTRowImpl cr = (CTRowImpl) r.getCTRow();
>>>
>>> the content of cr is
>>>
>>> <xml-fragment r="1" spans="1:3" x14ac:dyDescent="0.25"
>>> xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships";
>>> xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006";
>>> xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac";
>>> xmlns:main="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
>>> <main:c r="A1" s="1" t="s">
>>> <main:v>0</main:v>
>>> </main:c>
>>> <main:c r="B1" s="1"/>
>>> <main:c r="C1" s="1"/>
>>> </xml-fragment>
>>>
>>> You can see in the first row attribute spans="1:3"
>>>
>>> Also if you call cr.getSpans() you will get the list of spans, in my
>>> case 1:3. But I am unable to edit this list. There is a method setSpans
>>> and it requires a parameter of type XMLSimpleList but I am unable to add
>>> values to this list.
>>>
>>> Probably it is possible to somehow edit this values from java but it
>>> seams to be rocket science.
>>>
>>> I am waiting for some replay regarding this issue.
>>>
>>> Cristian
>>>
>>> MSB wrote:
>>>>
>>>> Well, there is an option to center - no, pre Webster so it ought to be
>>>> centre - the cells contents across a selection in the CellStyle class
>>>> just as there is in Excel, but like you, I cannot see how to obviously
>>>> make use of it. Currently, I am thinking about trying to use the
>>>> ability to create a name to see if that will help but I cannot be sure.
>>>>
>>>> Do you know in advance which cells need to be treated in this way? If
>>>> so, you could create a template that POI would then be able to open and
>>>> populate with data. Secondly, if you do know which cells are to be
>>>> treated in this way, you could create styles on another sheet in the
>>>> workbook and then try applying them to other cells in another sheet of
>>>> the same workbook. Again, I do not know if this would work but it
>>>> should be quick enough and easy enough to try out.
>>>>
>>>> When I get back homw after work today, I will have a play to see what I
>>>> can come up with.
>>>>
>>>> Yours
>>>>
>>>> Mark B
>>>>
>>>>
>>>> Cristian Petrula wrote:
>>>>>
>>>>> Hi. I have a huge problem. I need to use ALIGN_CENTER_SELECTION over
>>>>> 2, 3..
>>>>> cells but I am not allowed to merge cells And I don't have any idea
>>>>> how to
>>>>> simulate cell selection. I saw in xml file attribute "spans" in row
>>>>> element.
>>>>> Do you know how to use this align style with selected cells?
>>>>>
>>>>> Cristian
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
--
View this message in context:
http://old.nabble.com/ALIGN_CENTER_SELECTION-question-tp28660795p28671048.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
