Difference between revisions of "User:Danielbw"

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 3: Line 3:
 
==== Goal ====
 
==== 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.
 
: 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 ====
 
==== Specifications ====
 
::[[Media:TabBgColor_specs.odt|TabBgColor_specs.odt]]
 
::[[Media:TabBgColor_specs.odt|TabBgColor_specs.odt]]
 
==== Patches ====
 
==== Patches ====
 +
==== Test Files ====
 +
All Test Files Must have the following:
 +
10 Sheets Named Sheet1 to Sheet10
 +
Colors: Sheet1
 +
* Excel 2002, .xls, Binary format:
 +
* Excel 2003, .xls, Binary format:
 +
* Excel 2003, .xml, XML spreadsheet format:
 +
* Excel 2003, .xls, Binary format:
 +
* Excel 2007, .xls, Binary format:
 +
 +
 
----
 
----
 
--[[User:Danielbw|Danielbw]] 04:41, 21 January 2009 (UTC)
 
--[[User:Danielbw|Danielbw]] 04:41, 21 January 2009 (UTC)
 
----
 
----

Revision as of 22:41, 21 January 2009

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

TabBgColor_specs.odt

Patches

Test Files

All Test Files Must have the following: 10 Sheets Named Sheet1 to Sheet10 Colors: Sheet1

  • Excel 2002, .xls, Binary format:
  • Excel 2003, .xls, Binary format:
  • Excel 2003, .xml, XML spreadsheet format:
  • Excel 2003, .xls, Binary format:
  • Excel 2007, .xls, Binary format:



--Danielbw 04:41, 21 January 2009 (UTC)


Personal tools