This content has been marked as final. Show 25 replies
Option to have freeze panes and automatic filters ready to Excel
What is a freeze pane?
it is when you freeze row or column.
You find it in Excel 2007 under "View" menu
Edited by: jarola on Dec 8, 2010 12:22 PM
And you can see it in action if you go
Press Excel icon below IR to download Excel. There is some issue with Excel 2007 and you get warning popup. Just press Yes.
When you scroll down Excel header row is visible all the time
Code is modified version from Denes Kubicek solution
Edited by: jarola on Dec 8, 2010 12:24 PM
The only thing I have to suggest is to do with text fields being converted into dates.
i.e. If i insert into a cell: 15/6 ; it is converted to 15/06/2010. Which if I then go and edit to make a normal field again, is converted to the number 40344. Obviously not practical. When you insert the value with the character ' before the value, it isn't altered to a date.
so any field like:
should be inserted into the cell as
On a side note, Jari, I tried your example - freeze pane isn't occuring for me, using Open Office. Probably works fine in MS office, just saying.
Yes, freeze panes, automatic filter and header row cells color do not work with Open Office
How can download example in it,Thank you
You can not download, sorry
Done, see http://www.apex-plugin.com/oracle-apex-plugins/process-type-plugin/ir-report-to-excel-xlsx_74.html
I have downloaded your plugin, installed it and involved in one my application. I made proces on page with interactive report, set one button to run this process, but nothing happened. You didn't write any help or user guide. Can you please give one example how to use your plugin in application? Tnx!
Didn't I included a readme.txt?
In there you could read:
Hope this helps,
To use this plugin add a new process to a page in your application, based on this plugin. Use as Process Point "On Load - Before Header" Use a Condition Type "Request = Expression 1" Add a Region Button to your page. I use a HTML Button with Action "Redirect to Page in this Application", but other type will probably function too. The Redirected Page should be the same page, also button, process and report should all be on the same page. And use as Request the same value you have used in the Condition of the process.
Yes, you did include readme.txt into package file, sorry, it was my mistake. I did exactly you said, and after page running, pressing on a button I got this message:
Oops, something went wrong in NL.AMIS.SCHEFFER.PROCESS.XLSX
ORA-29294: A data error occurred during compression or uncompression.
This could be caused by
** calling this plugin on a page without a Report Region*
** specifying a non-existing Report name*
- On my page(10), I have Interactive Report Region called PLANS.
- Process name i ExcelExoirt, Process Point is On Load - Before Header, all Settings are YES, and Region name is PLANS. Condition Type is Request = Expression 1, and value of Expression 1 field is EXCEL.
- Region Button name is EXCELBTN, Action is Redirect to Page in this Application, Page is 10, Request is EXCEL.
What I made wrong?!
I don't think you did anything wrong. As the error message says, something went wrong in the plugin. But it's hard to say what exactly, or why.
The plugin uses a Excel template, which is compressed. This template is loaded when the plugin is installed, and stored inside the APEX repository tables.
And after generating the excel file, the file is compressed.
If you run the application in debug mode, the plugin stores a more complete error message, and line number, in the debug messages. Could you try that, and give me the complete error message?
And try leaving the setting for "Region Name" empty.
I think this is a error message:
ORA-06512: at "SYS.UTL_SYS_COMPRESS", line 56 ORA-06512: at "SYS.UTL_SYS_COMPRESS", line 226 ORA-06512: at "SYS.UTL_COMPRESS", line 89 ORA-06512: at line 154 ORA-06512: at line 289