Money Format

Aspose.Words Product Family
1

Got a problem with money format.

\# ".0,00 €" results is 12.345,67 without euro sign

\# "€ .0,00" results is € 12345,67 without . thousand separator

What I hope to get is € 12.345,67

Aspose.Words for .NET 13.1.0

2

Hi Martijn,

Thanks for your inquiry. To ensure a timely and accurate response please supply us with the following information, if you cannot supply us with this information we will not be able to investigate your issue and raise a ticket.

  • What environment are you running on?
    • OS (Windows Version or Linux Version)
    • Architecture (32 / 64 bit)
    • .NET Framework version (or Java version )
    • Provide information about your specific culture, such as the name of the culture, language and country/region.
  • Please supply us with the code from your application that is causing the issue
  • Please supply us with the input document that is causing the issue
  • Please supply us with the output document showing the undesired behavior
  • Please supply us with the expected document showing the desired behavior (You can create this document using Microsoft Word).

As soon as you get these pieces of information to us we’ll start our investigation into your issue.

Many thanks,

3

Enviroment:
Windows 7 Professional SP1 64-bit
.NET 4.0
Culture is set to “nl-NL”

Code:

public void MergeDocument(Stream source, Stream output, SaveTypes saveType = SaveTypes.Pdf)
{
    using (new CultureChange(new CultureInfo("nl-NL")))
    {
        Document document = new Document(source);
        // document.MailMerge.CleanupOptions = MailMergeCleanupOptions.RemoveUnusedFields | MailMergeCleanupOptions.RemoveUnusedRegions | MailMergeCleanupOptions.RemoveEmptyParagraphs;
        // document.MailMerge.CleanupOptions = MailMergeCleanupOptions.RemoveUnusedFields;
        document.MailMerge.CleanupOptions = MailMergeCleanupOptions.None;

        // Images
        // if (_mergeData.MergeImages != null)
        // document.MailMerge.FieldMergingCallback = new HandleMergeImageFieldFromBlob(_mergeData.MergeImages);

        // Fields);
        if (_mergeData.MergeFields != null)
            document.MailMerge.Execute(_mergeData.MergeFields.Keys.ToArray(), _mergeData.MergeFields.Values.ToArray());

        // Tables
        //if (_mergeData.DataSet != null)
        // document.MailMerge.ExecuteWithRegions(_mergeData.DataSet);

        // ExecuteCustomLogicOnEmptyRegions(document, new EmptyRegionsHandler(_mergeData.RemoveTables));

        document.MailMerge.DeleteFields();

        // For Images
        SaveOptions saveOptions = DocumentConverter.GetSaveOptions(saveType);

        // For Mail
        //HtmlSaveOptions options = new HtmlSaveOptions(SaveFormat.Html);
        // options.ImageSavingCallback

        if (saveOptions == null)
            document.Save(output, (SaveFormat)(int)saveType);
        else
            document.Save(output, saveOptions);
    }
}

public class CultureChange : IDisposable
{
    private readonly CultureInfo _originalCulture;

    public CultureChange(CultureInfo cultureInfo)
    {
        _originalCulture = Thread.CurrentThread.CurrentCulture;
        Thread.CurrentThread.CurrentCulture = cultureInfo;
    }

    #region Implementation of IDisposable

    public void Dispose()
    {
        Thread.CurrentThread.CurrentCulture = _originalCulture;
    }

    #endregion
}
4

Hi Martijn,

Thanks for the additional information. While using the latest version of Aspose.Words i.e. 13.1.0, I managed to reproduce this issue on my side. I have logged this issue in our bug tracking system. The issue ID is WORDSNET-7761. Your request has also been linked to this issue and you will be notified as soon as it is resolved. Sorry for the inconvenience.

Best regards,

5

The issues you have found earlier (filed as WORDSNET-7761) have been fixed in this .NET update and this Java update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.