cancel
Showing results for 
Search instead for 
Did you mean: 

Matrix.SetCellWithoutValidation new 2007 SP01 PL10 feature!!!

Trinidad
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi all,

Hotfix for SAP BUSINESS ONE 2007A SP01 Patch 10 includes a new and very interesting feature regarding matrixes.

A new "SetCellWithoutValidation" method has been added to the UI API Matrix object giving you the possibility to directly set cell values corresponding to UDFs in B1 system form matrixes without having to go over the columns + cells collections.

This new method offers you very good performances, so please use this method every time you need to change values in UDF columns for B1 system form matrixes.

SetCellWithoutValidation(Row, Col, Value)

Value is always a string value (converted into the UDF type accordingly). Date values must be inserted in the format: "YYYYMMDD".

This method is called WithoutValidation, it does only minimal validations on the value in order to maximize performance. Valid Values are therefore not validated.

Don't forget also to check other new matrix and grid capabilities already released in [B1 2007 SP01 PL09|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17255] [original link is broken] [original link is broken] [original link is broken];.

Take advantage of this new feature

Regards

Trinidad.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

This method sounds excellent...

Best Regards.

gab

Former Member
0 Kudos

Hi Maria,

thanks for this useful information.

Do you know anything about availability to change colors, editability, textstyle of only 1 cell in a matrix ?

I think it's really useful for us developers and i do not understand why SAP does not provide us.

Bye.

F.

Former Member
0 Kudos

Dear Fausto Scordato,

Cell level configuration has been developed in 8.8 SP1.

Thanks,

Warren

AdKerremans
Active Contributor
0 Kudos

Hi,

In wich patch for 8.8 will this be available?

Thanks

Ad