User:Danielbw
From Apache OpenOffice Wiki
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 13 Tabs...
- 10 Worksheets, named Sheet1 through Sheet10
- 1 Chart named Chart1
- 1 Ms Excel 4.0 Macro named Macro1
- 1 Ms Excel 5.0 Dialog' named Dialog1
- Test File name: calc_tabcolortest_xl_<Excel Version>_<Excel Format: Binary=bin;XML=xml>.<Excel File Extension> e.g. calc_tabcolortest_xl_2002_bin.xls for Excel 2002 binary format.
- The Thirteen Tabs need to bo colored according to the table below...
| 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 | |
| Chart1 | Blue | 000080 | |
| Macro1 | Olive | 808000 | |
| Dialog1 | Purple | 800080 |
Test Files
- Excel 2002 / Excel XP
- Binary format only.
- File extensions supported by OpenOffice.org: .xls, .xlt
- Testing Status: Cannot test. Test files are not available..
- Excel 2003
- Binary Format and OOXML formats.
- File extensions supported by OpenOffice.org
- Binary formats: .xls, .xlt
- OOXML formats: .xml (XML Spreadsheet)
- Testing Status
| File Type | Test | Result | Comments |
|---|---|---|---|
| .xls, .xlt (Binary) | Import color index for Worksheet tabs | OK | |
| .xls, .xlt (Binary) | Import color index for Chart tabs | Fail | |
| .xls, .xlt (Binary) | Import color index for MS Excel 4.0 Macro tabs | OK | |
| .xls, .xlt (Binary) | Import Color index for MS Excel 5.0 Dialog tabs | OK | |
| .xls, .xlt (Binary) | Export color index for Worksheet tabs | Not Ready | |
| .xls, .xlt (Binary) | Export color index for Chart tabs | Not Ready | |
| .xls, .xlt (Binary) | Export color index for MS Excel 4.0 Macro tabs | Not Ready | |
| .xls, .xlt (Binary) | Export Color index for MS Excel 5.0 Dialog tabs | Not Ready |
| File Type | Test | Result | Comments |
|---|---|---|---|
| .xml (XML Spreadsheet) | Import color index for Worksheet tabs | Not Ready | |
| .xml (XML Spreadsheet) | Export color index for Worksheet tabs | Not Ready |
- Excel 2007
- Binary Format and OOXML formats.
- File extensions supported by OpenOffice.org
- Binary formats: .xlsb
- OOXML formats: .xlsx, .xlsm, .xltx, .xltm (XML Spreadsheet)
- Download Excel 2007 Test Files -> http://wiki.services.openoffice.org/w/images/3/30/Excel_2007_colortabs.zip
- Testing Status
| File Type | Test | Result | Comments |
|---|---|---|---|
| .xlsb (Binary) | Import color index for Worksheet tabs | Not Ready | |
| .xlsb (Binary) | Import color index for Chart tabs | Not Ready | |
| .xlsb (Binary) | Import color index for MS Excel 4.0 Macro tabs | Not Ready | |
| .xlsb (Binary) | Import color index for MS Excel 5.0 Dialog tabs | Not Ready | |
| .xlsb (Binary) | Export color index for Worksheet tabs | Not Ready | |
| .xlsb (Binary) | Export color index for Chart tabs | Not Ready | |
| .xlsb (Binary) | Export color index for MS Excel 4.0 Macro tabs | Not Ready | |
| .xlsb (Binary) | Export color index for MS Excel 5.0 Dialog tabs | Not Ready |
| Excel Version | File Format | File Ext. | Download Link | Comments | Status |
|---|---|---|---|---|---|
| 2002 / XP | Binary | .xls | tabcolortest_xl_2002_bin.xls | BIFF8 | Testing Not Started |
| .xlt | tabcolortest_xl_2002_bin.xlt | BIFF8 | Testing Not Started | ||
| 2003 | Binary | .xls | calc tabcolortest xl 2003 bin.xls | BIFF8, BIFF11? Import Test: OK Export Test: N/A (Code not completed) |
Testing |
| .xlt | calc tabcolortest xl 2003 bin xlt.zip | BIFF8, BIFF11? Import Test: OK Export Test: N/A (Code not completed) |
Testing | ||
| 2007 | Binary | .xlsb | blah | Testing Not Started |
| Excel Version | File Format | File Ext. | Download Link | Comments | Status |
|---|---|---|---|---|---|
| 2003 | XML Spreadsheet | .xml | calc tabcolortest xl 2003 xml xml.zip | Import Test: Failed Export Test: N/A (Code not completed) |
Testing |
| 2007 | OOXML: Excel Spreadsheet: Macro-free | .xlsx | tabcolortest_xl_2007_ooxml.xlsx | Testing Not Started | |
| OOXML: Excel Spreadsheet: Macro-enabled | .xlsm | tabcolortest_xl_2007_ooxml.xlsm | Testing Not Started | ||
| OOXML: Excel Template: Macro-free | .xltx | tabcolortest_xl_2007_ooxml.xltx | Testing Not Started | ||
| OOXML: Excel Template: Macro-enabled | .xltm | tabcolortest_xl_2007_ooxml.xltm | Testing Not Started |
Danielbw 01:27, 22 January 2009 (UTC)
