rusbrown / plsql-utils

Automatically exported from code.google.com/p/plsql-utils
0 stars 0 forks source link

xlsx_builder_pkg cell border set without modifing value #23

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Compile xlsx_builder_pkg package.
2. Set a value to a cell with xlsx_builder_pkg.cell(1,1, 'Hello World');
3. Try to set border to the same cell.
4. Save to file xlsx_builder_pkg.save( 'C:\', 'test.xlsx' );

What is the expected output? What do you see instead?
I expect the cell to have a border. The problems is you cannot set a border 
without modifing the value of a cell. There is no such function.
xlsx_builder_pkg.cell( 1, 1 , ??,p_borderId => xlsx_builder_pkg.get_border( 
'x', 'thin', 'x', 'x' ) );

What version of the product are you using? On what operating system?
Latest package - plsql-utils-v170.zip

Please provide any additional information below.
There exists:
xlsx_builder_pkg.cell for number values
xlsx_builder_pkg.cell for string values
xlsx_builder_pkg.cell for date values

A simple function without setting a value would be of much use.

Example of new function call:
xlsx_builder_pkg.cell( 1, 1 , p_borderId => xlsx_builder_pkg.get_border( 'x', 
'thin', 'x', 'x' ) );

Original issue reported on code.google.com by RokXer on 17 Oct 2013 at 11:44