Matrix cell change format

Thomas Bühler

Hi all,

short question:

in one of our Optimizer rules I'd like to change a cell format inside a Matrix in C#.

I already have the Matrix object like this:

//SAP object

SAPbouiCOM.Form oSAPForm = SwissAddonFramework.B1Connector.GetB1Connector().Application.Forms.ActiveForm;

SAPbouiCOM.Item oItem = oSAPForm.Items.Item("38");

SAPbouiCOM.Matrix oMatrix = (SAPbouiCOM.Matrix) oItem.Specific;

Now I tried to access the column and also the cell, I can change e.g. the background color but I'd like to switch from a currency field to a double field (with more digits).

How can I do this?

Thanks and best regards,

Thomas

Thomas Bühler

Just to add:

I recognized that the column uses the "BoFieldsType" for it's format...so the question is simply: how can I change this type afterwards?

Anders Olsson

Hi Thomas,

This cannot be done. The number format is determined by the databind of the column and the decimal places setup in

Administration > System Initialisation > General Settings > Display (tab).

Regards,

Anders