ipmt function ignorning the i argument?

Fred Bone Fred.Bone at dial.pipex.com
Sun Oct 21 16:09:35 EDT 2012


On 21 October 2012 at 9:47, Marc Sherman said:

> On 10/21/2012 4:39 AM, Mike Evans wrote:
> >
> > Does this bug describe the issue you are having?
> >
> > https://bugzilla.gnome.org/show_bug.cgi?id=665883
> 
> Not exactly -- if I create a scheduled transaction with just i in the
> formula, it does properly increment. It only seems to fail with the more
> complicated ipmt function.
> 
> On 10/21/2012 6:27 AM, Yann Le Mouel wrote:
> >
> > Maybe this is related to this bug 670731 as well and that the
> > workaround works either.
> >
> > https://bugzilla.gnome.org/show_bug.cgi?id=670731
> >
> > Be aware that modifying the data file is not supported so do a proper
> > backup before...
> 
> That's a lot closer. In this bug, the filer says that it only fails with a
> non-zero fv parameter, but I'm giving it 0 for fv.
> 
> I tried the workaround, but my .gnucash file is in a binary format, so I
> can't edit it. This is despite the fact that in the save dialog, I
> selected "xml" from the format dropdown. Is that a known bug on windows,
> and if so, is there any way to work around it to get an XML formatted
> gnucash file?

You are saving the file compressed, for which GNucash uses the gzip 
format.

Two options:

1. Save it uncompressed (Edit->Preferences, General, Compress files)
2. Uncompress the file using a suitable program; I use 7-zip 
<www.7-zip.org>




More information about the gnucash-user mailing list