Bug 7003 - HSSF 2.0 Property/feature checklist
Summary: HSSF 2.0 Property/feature checklist
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: Other other
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-03-09 20:14 UTC by Andy Oliver
Modified: 2006-07-26 05:06 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Andy Oliver 2002-03-09 20:14:11 UTC
This bug is intended as a "property exposed through the usermodel" checklist. 
These are things not specifically mentioned in the Vision Document (like
formulas and graphing were).  Lots of interest lately in getting involved and
this is the place to start.  Probably best to buy the book ( its out of print
but readily available -- I got one for $14.88 off of Amazon.com) and pick
something to work on.  As features are completed/etc please update this bug with
a one liner comment like "#1 done"...  BOOK = "Microsoft Excel 97 Developer's
kit" isbn: 1-57231-498-2

These properties we should endevour to cover in the 2.0 release and expose via
the high-level model:

1 Backup - whether to save backup versions of the XLS (p287)
2 Bottom Margin - inches margin when printing (p 290)
3 Codepage - (p 293 and others)
4 Footer - (p 317)
5 Horizontally Center - (p320)
6 Header - (p321)
7 HyperLink - (p-321) Stores a hyperlink -- need to learn how they save it (undoc'd)
8 Left Margin (p326) - width of the left margin in inches when printing
9 NAMEs (p320) - defines a name of a cell
10 Precision - (p372) - lets the user pick precision as displayed or not
11. Print gridlines - (p373) - lets user pick to turn gridlines on or off
12. Print Headers - (p373) - lets user turn on/off row/col headings
13. Right Margin (p376) - size of the right margin in inches
14. Selection (p384) - Cell selections
15. Top margin (p413) - Top Margin in inches when sheet is printed 
16. Cented between vertical margins (p420)


These major features should be endevoured to support for the 2.0 release:

17 Increased support for MULBLANK/MULRK records - Requires a restructuring of
how HSSF handles cell values or an adapter class (probably the best way).  

18 Write support for RK records.

19 Custom Cell number formats 

Least likely (But never hurts to strive):

20 Custom Palettes (p369) - Excel lets you monkey around with custom pallettes.
 Might be good to support.
Comment 1 Andy Oliver 2002-06-09 03:28:08 UTC
4,6 are done
Comment 2 Shawn Laubach 2002-07-21 23:37:06 UTC
#2, #8, #13, #15 done
#11 done
Comment 3 Andy Oliver 2002-07-21 23:49:13 UTC
That leaves these opportunities: 

1 Backup - whether to save backup versions of the XLS (p287)
3 Codepage - (p 293 and others)
5 Horizontally Center - (p320)
7 HyperLink - (p-321) Stores a hyperlink -- need to learn how they save it (undoc'd)
9 NAMEs (p320) - defines a name of a cell
10 Precision - (p372) - lets the user pick precision as displayed or not
12. Print Headers - (p373) - lets user turn on/off row/col headings
14. Selection (p384) - Cell selections
16. Cented between vertical margins (p420)
17 Increased support for MULBLANK/MULRK records - Requires a restructuring of
how HSSF handles cell values or an adapter class (probably the best way).  
18 Write support for RK records.
19 Custom Cell number formats 
20 Custom Palettes (p369) - Excel lets you monkey around with custom pallettes.
 Might be good to support.

13/20 complete = 35%
Comment 4 Glen Stampoultzis 2002-07-22 11:40:57 UTC
#1 - Backup is done. (BTW, wouldn't this be better in the todo list??)
Comment 5 Andy Oliver 2002-07-22 12:57:02 UTC
So that leaves...

3 Codepage - (p 293 and others)
5 Horizontally Center - (p320)
7 HyperLink - (p-321) Stores a hyperlink -- need to learn how they save it (undoc'd)
9 NAMEs (p320) - defines a name of a cell
10 Precision - (p372) - lets the user pick precision as displayed or not
12. Print Headers - (p373) - lets user turn on/off row/col headings
14. Selection (p384) - Cell selections
16. Cented between vertical margins (p420)
17 Increased support for MULBLANK/MULRK records - Requires a restructuring of
how HSSF handles cell values or an adapter class (probably the best way).  
18 Write support for RK records.
19 Custom Cell number formats 
20 Custom Palettes (p369) - Excel lets you monkey around with custom pallettes.
 Might be good to support.

When I posted this bug the todo list didn't work yet.  (look at the date on it)
Heck if you ask me the todo list ought to link to a bugzilla query on everything
titled [TODO] *  so that I could edit it easily
Comment 6 Glen Stampoultzis 2002-07-22 13:57:37 UTC
Sounds like a good idea.  Ken awaits your patch...  :-)
Comment 7 Andy Oliver 2002-07-22 14:52:31 UTC
hehe... no I don't think he'd like that very much ;-)
Comment 8 Shawn Laubach 2002-10-03 15:33:18 UTC
#19 is done with patches from http://nagoya.apache.org/bugzilla/show_bug.cgi?
id=13219 and http://nagoya.apache.org/bugzilla/show_bug.cgi?id=13248
Comment 9 Shawn Laubach 2002-10-07 16:37:49 UTC
I don't know if you want to add:
21.  Ability to shift rows
22.  Ability to shift columns

If so, 21 is done.
Comment 10 Jason Height 2006-07-26 12:06:41 UTC
Well this didnt really cause a block to the 2.0 release ;-)

Cleaning up and marking as invalid.

Jason