Difference between revisions of "User:Danielbw"
From Apache OpenOffice Wiki
(→Download Test Files) |
(→Test Files) |
||
| Line 7: | Line 7: | ||
==== Patches ==== | ==== Patches ==== | ||
==== Test Files ==== | ==== Test Files ==== | ||
| − | ===== Test File Specifications ===== | + | :===== Test File Specifications ===== |
| − | :All Test Files Must conform to the following rules: | + | ::All Test Files Must conform to the following rules: |
| − | :* Workbook must have 10 Worksheets named Sheet1 through Sheet10 in order. | + | ::* Workbook must have 10 Worksheets named Sheet1 through Sheet10 in order. |
| − | :* Test File name: TabColorTestFile_Excel_<Excel Version>_<Excel Format: Binary=bin;XML=xml>.<Excel File Extension> e.g ''tabcolortestfile_excel_2002_bin.xls'' for Excel 2002 binary format. | + | ::* Test File name: TabColorTestFile_Excel_<Excel Version>_<Excel Format: Binary=bin;XML=xml>.<Excel File Extension> e.g ''tabcolortestfile_excel_2002_bin.xls'' for Excel 2002 binary format. |
| − | :* The Ten Worksheets need to bo colored according to the table below... | + | ::* The Ten Worksheets need to bo colored according to the table below... |
{| border="1" cellspacing="0" cellpadding="2" | {| border="1" cellspacing="0" cellpadding="2" | ||
|+Sheet Tab Colors | |+Sheet Tab Colors | ||
| Line 98: | Line 98: | ||
| Not Tested | | Not Tested | ||
|} | |} | ||
| − | :* Binary Formats | + | ---- |
| − | ::* Excel 2002, .xls, Binary format<br>BIFF8<br>tabcolortestfile_excel_2002_bin.xls | + | ::* Binary Formats |
| + | :::* Excel 2002, .xls, Binary format<br>BIFF8<br>tabcolortestfile_excel_2002_bin.xls | ||
::* Excel 2003, .xls, Binary format<br>BIFF8, BIFF11<br>tabcolortestfile_excel_2003_bin.xls < ''<span style="background-color:yellow">Need to create this file</span>'' | ::* Excel 2003, .xls, Binary format<br>BIFF8, BIFF11<br>tabcolortestfile_excel_2003_bin.xls < ''<span style="background-color:yellow">Need to create this file</span>'' | ||
::* Excel 2007, .xlsb, Binary format | ::* Excel 2007, .xlsb, Binary format | ||
Revision as of 00:31, 22 January 2009
Contents
Projects
Calc: Tab Background Color
Goal
- To gain the functionality provided by Microsoft Excel versions 2002 and higher. Microsoft Excel 2002 introduced Colored Tab Support for Excel. This gave users the ability to color code their spreadsheet tabs. The Goal of this project is to bring this functionality to OpenOffice.org. I realize that ods does not have the capability to store this information and that this project only benefits those who save to an excel format. I am interested in anyone's help that can help me find the way to extend the capability of the ods format to save tab color information. I have not spent a lot of time researching this yet. For simplicity's sake, I will start a second project for that enhancement.
Specifications
Patches
Test Files
- ===== Test File Specifications =====
- All Test Files Must conform to the following rules:
- Workbook must have 10 Worksheets named Sheet1 through Sheet10 in order.
- Test File name: TabColorTestFile_Excel_<Excel Version>_<Excel Format: Binary=bin;XML=xml>.<Excel File Extension> e.g tabcolortestfile_excel_2002_bin.xls for Excel 2002 binary format.
- The Ten Worksheets need to bo colored according to the table below...
- All Test Files Must conform to the following rules:
| Sheet Name | Sample | Color Name | Color RGB |
|---|---|---|---|
| Sheet1 | Black | 000000 | |
| Sheet2 | White | FFFFFF | |
| Sheet3 | Bright Red | FF0000 | |
| Sheet4 | Bright Green | 00FF00 | |
| Sheet5 | Bright Blue | 0000FF | |
| Sheet6 | Bright Yellow | FFFF00 | |
| Sheet7 | Magenta | FF00FF | |
| Sheet8 | Cyan | 00FFFF | |
| Sheet9 | Maroon | 800000 | |
| Sheet10 | Green | 008000 |
Download Test Files
| Excel Version | File Format | File Extension Type | Download Link | Comments |
|---|---|---|---|---|
| 2002 / XP | Binary | .xls | tabcolortestfile_excel_2002_bin.xls | BIFF8 < Testing |
| 2003 | Binary | .xls | tabcolortestfile_excel_2003_bin.xls | BIFF8, BIFF11 < Testing |
| 2003 | XML Spreadsheet | .xml | tabcolortestfile_excel_2003_xml.xml | Not Tested |
- Binary Formats
- Excel 2002, .xls, Binary format
BIFF8
tabcolortestfile_excel_2002_bin.xls
- Excel 2002, .xls, Binary format
- Excel 2003, .xls, Binary format
BIFF8, BIFF11
tabcolortestfile_excel_2003_bin.xls < Need to create this file - Excel 2007, .xlsb, Binary format
- (Unkown)
- tabcolortestfile_excel_2007_bin.xlsb < Need to create this file
- XML Formats
- Excel 2003, .xml, XML spreadsheet format
- (Unkown)
- Need Test File < Not ready for testing yet
- OOXML Formats
- Excel 2007, .xlsx, Binary format
- (Unkown)
- Need Test File < Not ready for testing yet
--Danielbw 04:41, 21 January 2009 (UTC)
