How to implement a custom format to pivotField dataField?

[FNeves]

Hi, I like to format pivotField Numbers(dataField) with custom formating like:

style.setCustom("#,##0000") -> pivotField.setCustom(“R$ #.##,0000”)

but reading the java api reference and implementing the code, i see that only the setNumber method it´s avaliable…

There´s a way of use custom format on pivot dataFields?

Thanks.

[Amjad_Sahi]

Hi,

Well, I am afraid, PivotField.setCustom method is not available at the moment. I have logged your feature request with an id: CELLSJAVA-18328. We will provide the supported version soon.

Thank you.

[Amjad_Sahi]

Hi,

Please try the new fix (attached). We have supported to set custom number format for pivot fields:

void com.aspose.cells.PivotField.setNumberFormat(String numberFormat)

Parameters:

numberFormat the custom display format of numbers and dates.


Thank you.

[FNeves]

It Works!

Thank´s for the fix!!

[aspose.notifier]

The issues you have found earlier (filed as 18328) have been fixed in this update.

---

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