XLS - Revision history

Dexvertbot: Change telparia.com samples link to template

2023-12-28T04:07:16Z

Change telparia.com samples link to template

2023-10-24T04:16:57Z

‎Versions

2023-10-24T02:10:21Z

2023-10-23T23:38:43Z

‎References

2023-10-23T23:38:32Z

‎References

2023-09-02T17:11:00Z

‎External links

2023-09-02T17:08:40Z

‎External links: Updating Forensics Wiki links

2021-05-24T22:03:33Z

‎Sample files

2020-11-27T00:13:15Z

add ForensicsWiki entry link

2019-08-07T22:44:26Z

Fixed broken link via data.cdlib.org to uc3.cdlib.org ("Abandon all hope, ye who enter dates in Excel")

@@ Line 47: / Line 47: @@
 == Sample files ==
 * [http://labs.nationalarchives.gov.uk/wordpress/index.php/2014/01/datasets/ National Archives (UK) datasets (includes some XLS files)]
-* https://telparia.com/fileFormatSamples/document/xls/
+* {{DexvertSamples|document/xls}}
 ==References==

@@ Line 16: / Line 16: @@
 ===Versions===
 {| class="wikitable"
-! Version !! BIFF Version !! Document type !! Year
+! Version !! BIFF Version !! Document type !! PRONOM !!Year
 |-
-|Excel 2.x || BIFF2  || Worksheet || 1987
+|Excel 2.x || BIFF2  || Worksheet || {{PRONOM|fmt/55}} || 1987
 |-
-|Excel 3.0 || BIFF3  || Worksheet || 1990
+|Excel 3.0 || BIFF3  || Worksheet || {{PRONOM|fmt/56}} || 1990
 |-
-|Excel 4.0 || BIFF4  || Worksheet || 1992
+|Excel 4.0 || BIFF4  || Worksheet || {{PRONOM|fmt/57}} || 1992
 |-
-|Excel 5.0 || BIFF5  || Workbook || 1993
+|Excel 5.0 || BIFF5  || Workbook || {{PRONOM|fmt/59}} || 1993
 |-
-|Excel 7.0 || BIFF5  || Workbook || 1995
+|Excel 7.0 || BIFF5  || Workbook || {{PRONOM|fmt/59}} || 1995
 |-
-|Excel 8.0 || BIFF8  || Workbook || 1997
+|Excel 8.0 || BIFF8  || Workbook || {{PRONOM|fmt/61}} || 1997
 |-
-|Excel 9.0 || BIFF8  || Workbook || 1999
+|Excel 9.0 || BIFF8  || Workbook || {{PRONOM|fmt/62}} || 1999
 |-
-|Excel 10.0 || BIFF8  || Workbook || 2001
+|Excel 10.0 || BIFF8  || Workbook || {{PRONOM|fmt/62}} || 2001
 |-
-|Excel 11.0 || BIFF8  || Workbook || 2003
+|Excel 11.0 || BIFF8  || Workbook || {{PRONOM|fmt/62}} || 2003
 |}

← Older revision		Revision as of 02:10, 24 October 2023
Line 13:		Line 13:

	Later Excel versions use [[XLSX]] as their native format, though they still support the older format as well.		Later Excel versions use [[XLSX]] as their native format, though they still support the older format as well.
		+
		+	===Versions===
		+	{\| class="wikitable"
		+	! Version !! BIFF Version !! Document type !! Year
		+	\|-
		+	\|Excel 2.x \|\| BIFF2 \|\| Worksheet \|\| 1987
		+	\|-
		+	\|Excel 3.0 \|\| BIFF3 \|\| Worksheet \|\| 1990
		+	\|-
		+	\|Excel 4.0 \|\| BIFF4 \|\| Worksheet \|\| 1992
		+	\|-
		+	\|Excel 5.0 \|\| BIFF5 \|\| Workbook \|\| 1993
		+	\|-
		+	\|Excel 7.0 \|\| BIFF5 \|\| Workbook \|\| 1995
		+	\|-
		+	\|Excel 8.0 \|\| BIFF8 \|\| Workbook \|\| 1997
		+	\|-
		+	\|Excel 9.0 \|\| BIFF8 \|\| Workbook \|\| 1999
		+	\|-
		+	\|Excel 10.0 \|\| BIFF8 \|\| Workbook \|\| 2001
		+	\|-
		+	\|Excel 11.0 \|\| BIFF8 \|\| Workbook \|\| 2003
		+	\|}

	==Handling of date values==		==Handling of date values==

@@ Line 33: / Line 33: @@
 * [http://support.microsoft.com/kb/180162 XL: The 1900 Date System vs. the 1904 Date System]
 * [http://decalage.info/file_formats_security/office MS Office 97-2003 legacy/binary formats security] - article with lots of resources on MS Office formats, including analysis techniques, tools and parsing libraries
-* [https://www.openoffice.org/sc/excelfileformat.pdf Open Office - Excel Versions 2, 3, 4, 5, 95, 97, 2000, XP, 2003.
+* [https://www.openoffice.org/sc/excelfileformat.pdf Open Office - Excel Versions 2, 3, 4, 5, 95, 97, 2000, XP, 2003]
 == External links ==

@@ Line 33: / Line 33: @@
 * [http://support.microsoft.com/kb/180162 XL: The 1900 Date System vs. the 1904 Date System]
 * [http://decalage.info/file_formats_security/office MS Office 97-2003 legacy/binary formats security] - article with lots of resources on MS Office formats, including analysis techniques, tools and parsing libraries
 == External links ==

@@ Line 35: / Line 35: @@
 == External links ==
-* [{{ForensicsWikiURL|excel_spreadsheet_%28xls%29}} ForensicsWiki entry]
+* [{{ForensicsWikiURL|excel_spreadsheet_%28xls%29}} ForensicsWiki entry] (need to copy over whatever relevant details are available)
 [[Category:Microsoft]]
 [[Category:Microsoft Compound File]]

@@ Line 29: / Line 29: @@
 * [http://www.joelonsoftware.com/items/2008/02/19.html Why are the Microsoft Office file formats so complicated? (And some workarounds)]
 * [http://www.advisorone.com/2013/04/16/oops-reinhart-rogoff-research-tripped-up-by-typo?t=theory-strategy Typo in Excel spreadsheet apparently led to erroneous result in economic paper that was influential on government policy]
-* [http://datapub.cdlib.org/2014/04/10/abandon-all-hope-ye-who-enter-dates-in-excel/ Abandon all hope, ye who enter dates in Excel]
+* [https://uc3.cdlib.org/2014/04/09/abandon-all-hope-ye-who-enter-dates-in-excel/ Abandon all hope, ye who enter dates in Excel]
 * [http://support.microsoft.com/kb/180162 XL: The 1900 Date System vs. the 1904 Date System]
 * [http://decalage.info/file_formats_security/office MS Office 97-2003 legacy/binary formats security] - article with lots of resources on MS Office formats, including analysis techniques, tools and parsing libraries
 [[Category:Microsoft]]
 [[Category:Microsoft Compound File]]