Difference between revisions of "User:Danielbw"
From Apache OpenOffice Wiki
(→Download Test Files) |
(→Download Test Files) |
||
| Line 90: | Line 90: | ||
| tabcolortest_xl_2002_bin.xls | | tabcolortest_xl_2002_bin.xls | ||
| BIFF8 | | BIFF8 | ||
| − | | style="background-color: | + | | style="background-color: red; color: white" | Testing Not Started |
|- | |- | ||
| .xlt | | .xlt | ||
| tabcolortest_xl_2002_bin.xlt | | tabcolortest_xl_2002_bin.xlt | ||
| BIFF8 | | BIFF8 | ||
| − | | style="background-color: | + | | style="background-color: red; color: white" | Testing Not Started |
|- | |- | ||
| rowspan="2" | 2003 | | rowspan="2" | 2003 | ||
| Line 112: | Line 112: | ||
| Binary | | Binary | ||
| .xlsb | | .xlsb | ||
| − | | | + | |blah |
| | | | ||
| style="background-color: red; color: white" | Testing Not Started | | style="background-color: red; color: white" | Testing Not Started | ||
| Line 130: | Line 130: | ||
| XML Spreadsheet | | XML Spreadsheet | ||
| .xml | | .xml | ||
| − | | | + | |[[Media:calc tabcolortest xl 2003 xml xml.zip|calc tabcolortest xl 2003 xml xml.zip]] |
| | | | ||
| − | | | + | | style="background-color: yellow" | Testing |
|- | |- | ||
| rowspan="4" | 2007 | | rowspan="4" | 2007 | ||
| Line 139: | Line 139: | ||
| tabcolortest_xl_2007_ooxml.xlsx | | tabcolortest_xl_2007_ooxml.xlsx | ||
| | | | ||
| − | | Not | + | | style="background-color: red; color: white" | Testing Not Started |
|- | |- | ||
| OOXML: Excel Spreadsheet: Macro-enabled | | OOXML: Excel Spreadsheet: Macro-enabled | ||
| Line 145: | Line 145: | ||
| tabcolortest_xl_2007_ooxml.xlsm | | tabcolortest_xl_2007_ooxml.xlsm | ||
| | | | ||
| − | | Not | + | | style="background-color: red; color: white" | Testing Not Started |
|- | |- | ||
| OOXML: Excel Template: Macro-free | | OOXML: Excel Template: Macro-free | ||
| Line 151: | Line 151: | ||
| tabcolortest_xl_2007_ooxml.xltx | | tabcolortest_xl_2007_ooxml.xltx | ||
| | | | ||
| − | | Not | + | | style="background-color: red; color: white" | Testing Not Started |
|- | |- | ||
| OOXML: Excel Template: Macro-enabled | | OOXML: Excel Template: Macro-enabled | ||
| Line 157: | Line 157: | ||
| tabcolortest_xl_2007_ooxml.xltm | | tabcolortest_xl_2007_ooxml.xltm | ||
| | | | ||
| − | | Not | + | | style="background-color: red; color: white" | Testing Not Started |
|} | |} | ||
---- | ---- | ||
[[User:Danielbw|Danielbw]] 01:27, 22 January 2009 (UTC) | [[User:Danielbw|Danielbw]] 01:27, 22 January 2009 (UTC) | ||
Revision as of 03:10, 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...
| 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 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 | Testing |
| .xlt | calc tabcolortest xl 2003 bin xlt.zip | BIFF8, BIFF11 | 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 | 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)
