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

 
 

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

sr #105597: Export ledger values to spreadsheet

Submitted by:  Greg Chicares <chicares>
Submitted on:  Wed 27 Sep 2006 01:26:57 PM UTC  
 
Category: OutputStatus: None
Priority: 1 - LaterSeverity: 1 - Wish
Assigned to: NoneOpen/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>
Project 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>
Project Administrator

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    No Changes Have Been Made to This Item

    Back to the top


    Powered by Savane 3.1-cleanup