windows - Proper SpreadsheetML file extension -


i want create a spreadsheetml file on local drive can opened in ms excel or open office clicking on file in windows explorer.

i tried filename extensions registered microsoft excel find far. of them (.xls example) allows file opened, after "file in different format specified file extension" warning dialog. extensions (like .xlsx) causes excel show format error dialog without opening file.

wikipedia tells extension should .xml, registered opened web browser default.

this, this , this similar questions downloading file web , setting proper content-type. can not change content-type local file.

this article explains how annoying extension hardening mechanism works , how disable it, think wrong force user disable security features allow spreadsheet file opened.

so there no solution or missing something?

now open office can open .xlsx (and read) files , excel can open (and read) .ods files. suggestion pick 1 of them best suits audience , understanding of specific file format.

both of applications have advantages , disadvanges , non-supported features between 2 of them.

i suggest reviewing document differences between opendocument spreadsheet (.ods) format , excel (.xlsx) format.

when work 2 file formats, .xlsx , .ods, there might formatting differences, , not features available. you’ll able convert data , content, way work content might different depending on formats use.

one gotcha open office when save .xlsx file change format .ods file. both applications re-arrange folder structure after saving anyway.

the biggest change how go creating spreadsheetml files, both open office , excel have different folder structure depending on file extension use.

here short example of excel folder format.

-/  - _rels/    - .rels  - xl/    - _rels/      - workbook.xml.rels    - sheet1.xml    - workbook.xml  - [content_types].xml

i have created sample github repository sample open in both excel , open office.

https://github.com/nico-stackoverflow/proper-spreadsheetml-file-extension


Comments

Post a Comment

Popular posts from this blog

jOOQ update returning clause with Oracle -

according http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/update-statement/ jooq doesn't support returning clause in update statements databases except firebird , postgres. does know, still correct oracle jooq? according oracle's documentation, oracle db supports returning clase delete, insert, or update statements. incorrect manual you're right - manual wrong , should fixed: https://github.com/jooq/jooq/issues/5470 single row update returning jooq 3.8 added support single row update .. returning statements. internally, uses callablestatement , pl/sql block of form: begin update "my_table" set "my_table"."column" = 'xyz' "my_table"."id" = 1 returning "my_table"."id", "my_table"."column" ?, ?; ? := sql%rowcount; end; the relevant issue is: https://github.com/jooq/jooq/issues/5190 multi row update returning a...
Read more

java - Warning equals/hashCode on @Data annotation lombok with inheritance -

i have entity inherits other. on other hand, i'm using lombok project reduce boilerplate code, put @data annotation. annotation @data inheritance produces next warning: generating equals/hashcode implementation without call superclass, though class not extend java.lang.object. if intentional, add '@equalsandhashcode(callsuper=false)' type. is advisable add annotation @equalsandhashcode (callsuper = true) or @equalsandhashcode (callsuper = false) ? if not added, 1 callsuper=false or callsuper=true ? the default value false . 1 if don't specify , ignore warning. yes, recommended add @equalsandhashcode annotation on @data annotated classes extend else object. cannot tell if need true or false , depends on class hierarchy, , need examined on case-by-case basis. however, project or package, can configure in lombok.config call super methods if not direct subclass of object. lombok.equalsandhashcode.callsuper = call for configuration system ...
Read more

java - BasicPathUsageException: Cannot join to attribute of basic type -

i using java 8 jpa (hibernate 5.2.1). have clause works perfectly, until introduce clause make use foreign key table values too. i getting following error: basicpathusageexception: cannot join attribute of basic type i think problem related fact have join table, , not sure how create join using join table. employee - employee_category - category model (employee.java): @manytomany(cascade = cascadetype.all, fetch=fetchtype.eager) @jointable ( name="employee_category", joincolumns={ @joincolumn(name="emp_id", referencedcolumnname="id") }, inversejoincolumns={ @joincolumn(name="cat_id", referencedcolumnname="id") } ) private set<category> categories; model (category.java): @id private string id; jpa when introduce following code, fails error above (i think problem new piece of code): join<t, category> category = from.join("id"); predicates.add(criteriabuilder.like(category....
Read more