You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "arun.ka" <th...@gmail.com> on 2018/02/06 17:51:11 UTC

Re: showInPane does not work

Dear Mark,

Please help me to resolve the below

I have the same scenario but now I am dealing with HSSF Workbook and HSSF
Sheet.
Do we have any workaround for HSSF instead of XSSF.
<<<<
// First step is to get at the CTWorksheet bean underlying the worksheet. 
        ctWorksheet = sheet.getCTWorksheet(); 
        // From the CTWorksheet, get at the sheet views. 
        ctSheetViews = ctWorksheet.getSheetViews(); 
        // Grab a single sheet view from that array 
        ctSheetView =
ctSheetViews.getSheetViewArray(ctSheetViews.sizeOfSheetViewArray() - 1); 
        // Se the address of the top left hand cell. 
        ctSheetView.setTopLeftCell("A1"); 
>>>> 

Please advice.



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: showInPane does not work

Posted by "arun.ka" <th...@gmail.com>.
Dear POI Team,

Sorry for asking again.
Any updates.

BR,
Arun



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: showInPane does not work

Posted by "arun.ka" <th...@gmail.com>.
Dear POI Team,
I am very sorry for unclear post.
Let me explain the situation.
I have the template.xls, that consists of macro with freezed pane.
Steps, 
1. Reading the xls file (template.xls) from Input directory path
2. Writing the contents to that xls file[value pasting process based on
biz.]
3. Finally write it as new xls file [Target.xls] to output directory path

To do this, I am using the HSSFWorkbook, HSSFSheet etc.. stuffs.
So for everything is fine.

But, when I open the target file, view is showing at that bottom of the last
line like line number 350.
I have to manually move the vertical scrollbar to reach the next line of
freeze pane.

My requirement is it should be focus next line to freeze line when I open
the xls file. Meantime, xls file should not be corrupted. 
Note: First 6 line are freezed and locked.

Please help me.

If still it is unclear let me post my code, java and poi.jar version
details.

BR,
Arun




--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: showInPane does not work

Posted by Markus Sandmann <ma...@gmail.com>.
Sorry messed up, post went to the wrong list.

2018-02-07 13:37 GMT+01:00 Markus Sandmann <ma...@gmail.com>:

> Hi,
>
> hm? I already described what is not working. Using JDK 9 some Imports
> cannot be resolved using the same Libary and Code as with JDK 7 (where the
> imports do work).
> Screenshots and Codeparts can be seen in the linked StackOverFlow Post.
>
> I don't know what else i could say about the problem. Because of the
> failing imports I can't use the Classes and Functions in the code like -
> for example- :
>
> [...]
>
> private HashMap<XSSFColor, XSSFCellStyle> xssfStyles;
>
>     public XLSXFileGeneratorWorker(JLabel statusLabel, File file) {
>         this.statusLabel = statusLabel;
>         this.xlsxFile = file;
>         this.xssfStyles = new HashMap<XSSFColor, XSSFCellStyle>();
>     }
>
> [...]
>
> Where the XSSFColor can not be resolved due to the import issue, etc.
>
> Or another example as simple as:
>
> XSSFWorkbook workbook = new XSSFWorkbook();
>
> doesn't work either because of the import problem.
>
> And as already stated, as soon as i switch back to JDK7 the exact same
> code works.
> Hope it is clearer now.
>
> Greetings,
> Markus
>
>
> 2018-02-07 13:27 GMT+01:00 Murphy, Mark <mu...@metalexmfg.com>:
>
>> Not working is a very broad statement, what is happening, what did you
>> expect? What does your code look like?
>>
>> -----Original Message-----
>> From: arun.ka [mailto:thimsarun@gmail.com]
>> Sent: Wednesday, February 07, 2018 2:44 AM
>> To: user@poi.apache.org
>> Subject: Re: showInPane does not work
>>
>> Dear POI team and Mark,
>>
>> Please help me out of that issue.
>> showInPane not working for HSSF.
>>
>> BR,
>> ARUN
>>
>>
>>
>> --
>> Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
>> commands, e-mail: user-help@poi.apache.org
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>

Re: showInPane does not work

Posted by Markus Sandmann <ma...@gmail.com>.
Hi,

hm? I already described what is not working. Using JDK 9 some Imports
cannot be resolved using the same Libary and Code as with JDK 7 (where the
imports do work).
Screenshots and Codeparts can be seen in the linked StackOverFlow Post.

I don't know what else i could say about the problem. Because of the
failing imports I can't use the Classes and Functions in the code like -
for example- :

[...]

private HashMap<XSSFColor, XSSFCellStyle> xssfStyles;

    public XLSXFileGeneratorWorker(JLabel statusLabel, File file) {
        this.statusLabel = statusLabel;
        this.xlsxFile = file;
        this.xssfStyles = new HashMap<XSSFColor, XSSFCellStyle>();
    }

[...]

Where the XSSFColor can not be resolved due to the import issue, etc.

Or another example as simple as:

XSSFWorkbook workbook = new XSSFWorkbook();

doesn't work either because of the import problem.

And as already stated, as soon as i switch back to JDK7 the exact same code
works.
Hope it is clearer now.

Greetings,
Markus


2018-02-07 13:27 GMT+01:00 Murphy, Mark <mu...@metalexmfg.com>:

> Not working is a very broad statement, what is happening, what did you
> expect? What does your code look like?
>
> -----Original Message-----
> From: arun.ka [mailto:thimsarun@gmail.com]
> Sent: Wednesday, February 07, 2018 2:44 AM
> To: user@poi.apache.org
> Subject: Re: showInPane does not work
>
> Dear POI team and Mark,
>
> Please help me out of that issue.
> showInPane not working for HSSF.
>
> BR,
> ARUN
>
>
>
> --
> Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
> commands, e-mail: user-help@poi.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

RE: showInPane does not work

Posted by "Murphy, Mark" <mu...@metalexmfg.com>.
Not working is a very broad statement, what is happening, what did you expect? What does your code look like?

-----Original Message-----
From: arun.ka [mailto:thimsarun@gmail.com] 
Sent: Wednesday, February 07, 2018 2:44 AM
To: user@poi.apache.org
Subject: Re: showInPane does not work

Dear POI team and Mark,

Please help me out of that issue.
showInPane not working for HSSF.

BR,
ARUN



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Re: showInPane does not work

Posted by "arun.ka" <th...@gmail.com>.
Dear POI team and Mark,

Please help me out of that issue.
showInPane not working for HSSF.

BR,
ARUN



--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org