Megatest

View Ticket
Login
2015-09-24
14:08 Ticket [4f129ccb57] Refdb creation (from dat files) status still Open with 5 other changes artifact: a599968089 user: tyardeni
14:00 New ticket [4f129ccb57]. artifact: 327ecb0fa5 user: tyardeni

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 )