mainLet me illustrate... - Support: sr #105597, Export ledger values to spreadsheet

 
 

You are not allowed to post comments on this tracker with your current authentication level.

sr #105597: Export ledger values to spreadsheet

Submitter:  Greg Chicares <chicares>
Submitted:  Wed 27 Sep 2006 01:26:57 PM UTC
   
 
Category:  Output Status:  None
Priority:  1 - Later Severity:  1 - Wish
Assigned to:  None Open/Closed:  Open

Tue 28 Oct 2008 10:57:01 PM UTC, comment #1: 

It would be preferable to generate this tab-delimited text
file before Ledger::AutoScale() is called.

Greg Chicares <chicares>
Group administrator
Wed 27 Sep 2006 01:26:57 PM UTC, original submission:  

Export ledger values to spreadsheet. This is useful in markets
that require extensive customization of illustrations. It can be
done today, but only as a side effect that was tacked on to
printing in a great hurry:
(1) the steps are unintuitive
 - type 'idiosyncrasy_spreadsheet' in 'Comments'
 - run illustration
 - Print | preview [close preview: want only the side effect]
(2) the result shows the lack of deliberate design
 - the file always has the same name
 - older file instances are overwritten
 - if the file is already open, then no new file is written
(3) any change in file layout requires changes in downstream
spreadsheets that depend upon it.

Analysis:

(1) The file is created in
  void Ledger::write(xml::node& x) const
which probably should be refactored as part of this task
  http://savannah.nongnu.org/support/?105591
anyway. This facility may be inappropriate for some users, so it
is probably best to place it on a new home-office-only menu.

(2) Existing function
  unique_filepath()
could be used to create the file with a unique name.

(3) Users should be encouraged to use range names in spreadsheets
they create, to insulate themselves from changes. This file is a
simple tab-delimited representation of the 'ledger' object, with
column headers that are suitable for forming range names. When a
new column is added, it should be available in this file.

Greg Chicares <chicares>
Group administrator

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by chicares (Posted a comment)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

    No changes have been made to this item

    Back to the top

    Powered by Savane 3.14-f13d.
    Corresponding source code