Megatest

View Ticket
Login
Ticket Hash: 4f129ccb5735c3207c5db12d0f1c3bcfd705d3e2
Title: Refdb creation (from dat files)
Status: Open Type: Feature_Request
Severity: Important Priority: Immediate
Subsystem: Resolution: Open
Last Modified: 2015-09-24 14:08:11
Version Found In: 1.6024
Description:
Figured out the minimum requirement to create the sxml files required by gnumeric to open a refdb. This will allow import from csv or direct creation of .dat files
User Comments:
tyardeni added on 2015-09-24 20:08:11:

Each refdb requires the following two files:

  • sxml/_sheets.sxml:
(

; for each sheet, add the following, replace sheet_name with the sheet's name
(http://www.gnumeric.org/v10.dtd:SheetNameIndex
  (http://www.gnumeric.org/v10.dtd:SheetName
    (@ (http://www.gnumeric.org/v10.dtd:Rows "65536")
      (http://www.gnumeric.org/v10.dtd:Cols "256"))
     "sheet_name"))

)
  • smxl/_workbook.sxml:
(*TOP* (*PI* xml "version=\"1.0\" encoding=\"UTF-8\""))

In addition, each tab requires the following file:

  • sxml/_sheets.sxml:
(http://www.gnumeric.org/v10.dtd:Sheet )