Bug#1053672: Info received (Bug#1053672: Apple copyright notices in test .xlsx files)

2023-10-08 Thread Debian Bug Tracking System
Thank you for the additional information you have supplied regarding
this Bug report.

This is an automatically generated reply to let you know your message
has been received.

Your message is being forwarded to the package maintainers and other
interested parties for their attention; they will reply in due course.

Your message has been sent to the package maintainer(s):
 Debian Science Maintainers 

If you wish to submit further information on this problem, please
send it to 1053...@bugs.debian.org.

Please do not send mail to ow...@bugs.debian.org unless you wish
to report a problem with the Bug-tracking system.

-- 
1053672: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=1053672
Debian Bug Tracking System
Contact ow...@bugs.debian.org with problems



Re: Bug#1053672: Apple copyright notices in test .xlsx files

2023-10-08 Thread Paul Wise
On Sun, 2023-10-08 at 15:04 +0100, Rebecca N. Palmer wrote:

> Given this, why is that copyright notice there, and what does it imply 
> that we should do?  (E.g. does Apple Numbers automatically copy 
> Apple-owned items (e.g. fonts) into files it creates?  If so, is there a 
> way to remove these items to get a Free file?)

*.xlsx files are actually just *.zip files containing XML and other
files. The Apple copyright for both of the files you mention comes from
the Apple copyright listed for the ICC profile embedded in the EXIF
data in the JPEG file that was saved as a thumbnail of the spreadsheet.

I am not sure what that means for the license of the test cases in
openpyxl and but it would be easy to fix by either deleting the
thumbnail, or removing the ICC profile, but that would alter the test
cases, probably that wouldn't affect the tests passing/failing though.

$ unzip conditional-formatting.xlsx 
Archive:  conditional-formatting.xlsx
  inflating: [Content_Types].xml 
  inflating: _rels/.rels 
  inflating: xl/_rels/workbook.xml.rels  
  inflating: xl/workbook.xml 
 extracting: docProps/thumbnail.jpeg  
  inflating: xl/theme/theme1.xml 
  inflating: xl/styles.xml   
  inflating: xl/worksheets/sheet1.xml  
  inflating: docProps/core.xml   
  inflating: docProps/app.xml

$ grep -ri apple
grep: conditional-formatting.xlsx: binary file matches
grep: docProps/thumbnail.jpeg: binary file matches

$ exiftool docProps/thumbnail.jpeg | grep -i apple
Profile CMM Type: Apple Computer Inc.
Primary Platform: Apple Computer Inc.
Device Manufacturer : Apple Computer Inc.
Profile Creator : Apple Computer Inc.
Profile Copyright   : Copyright 2007 Apple Inc., all rights 
reserved.

-- 
bye,
pabs

https://wiki.debian.org/PaulWise


signature.asc
Description: This is a digitally signed message part


Bug#1053672: Apple copyright notices in test .xlsx files

2023-10-08 Thread Rebecca N. Palmer

Source: openpyxl
Version: 3.0.9-2
Severity: serious

licensecheck -r --copyright . on openpyxl finds these:

./openpyxl/formatting/tests/data/conditional-formatting.xlsx: UNKNOWN
  [Copyright: 2007 Apple Inc.]
./openpyxl/reader/tests/data/complex-styles.xlsx: UNKNOWN
  [Copyright: 2007 Apple Inc.]

If opened in 'less' these files do contain the text "Copyright 2007 
Apple Inc., all rights reserved.", marked as 'etext'.


However, if opened in LibreOffice, no _obvious_ command displays this 
text.  File > Properties instead displays creation and modification 
dates/authors that match the openpyxl upstream commit dates/authors 
(2012-4), which suggests that these are *not* straightforward copies of 
Apple-owned example files.


Their actual contents are mostly formatting, i.e. they look like 
something created specifically to be a test case for reading formatting, 
or possibly a documentation example for formatting but the above makes 
that less likely, not something copied from real-world use.


Given this, why is that copyright notice there, and what does it imply 
that we should do?  (E.g. does Apple Numbers automatically copy 
Apple-owned items (e.g. fonts) into files it creates?  If so, is there a 
way to remove these items to get a Free file?)