OO ALV Cell Merge Problem when editable fields

[Former Member]

Hi there!

I'm using OO ALV ( CL_GUI_ALV_GRID ) and experiencing a strange problem.

I'm interested in the cells merging functionality of ALV, when i sort data for a specific field.

It works fine but only if i do not set any field as editable ( lvc_s_fcat-edit = 'X' ).

For some reason ALV loses some of its functionality when you set a field as editable.

I've noticed it also with the functionality of expanding/supressing data when using subtotals.

If any field is set as editable then subtotals come always expanded, you cannot supress them...

Has anyone else experienced somethng like this before? Any help will be appreciated!

BR

George Zervas

[Former Member]

Hi there!

I'm using OO ALV ( CL_GUI_ALV_GRID ) and experiencing a strange problem.

I'm interested in the cells merging functionality of ALV, when i sort data for a specific field.

It works fine but only if i do not set any field as editable ( lvc_s_fcat-edit = 'X' ).

For some reason ALV loses some of its functionality when you set a field as editable.

I've noticed it also with the functionality of expanding/supressing data when using subtotals.

If any field is set as editable then subtotals come always expanded, you cannot supress them...

Has anyone else experienced somethng like this before? Any help will be appreciated!

BR

George Zervas

[Former Member]

Hi,

Check the bellow thread which give some idea on your requirement.

Regards,

Goutam Kolluru.

[Former Member]

Hi,

Check This [Thread|http://forums.sdn.sap.com/thread.jspa?threadID=928573] to solve your issue.

Check the User Command, first line should be call method cl_gui->check_changed_data().

Check this [url|http://wiki.sdn.sap.com/wiki/display/ABAP/InteractiveEditableOOALVgridwithdynamicitab,FCATandENTERkeyeventtrigger] for code to work on Interactive Editable OO ALV grid .

Hope will solve your issue.

Regards,

Saravana.S

Edited by: saravanasap on Feb 14, 2012 7:38 AM

[Former Member]

Hi there again,

goutam kolluru and saravanasap thank you for your replies but my question was targeting a specific problem.

I know how to achieve the merging functionality (by sorting the desired column), but as i explained before, this stops working the moment i set any field as editable ( lvc_s_fcat-edit = 'X' ).

BR

George Zervas

[former_member209088]

Yes, it appears as though making even one field editable in the ALV does a few things:

1) makes cell merge on Sort stop working

2) removes "KEY" colors on key fields

Seems like a bug to me.  This also affects the funciton 'REUSE_ALV_GRID_DISPLAY'.

I will be searching OSS, as I came across this problem today

-Tim

[Former Member]

Hi George and Timothy,

I am also facing the exact problem what george has mentioned.

When I make any of the field editable in ALV I am loosing the cell merging functionality.

Do you have any update or any inputs on this?

Thanks,

Uday.

[former_member209088]

Looks like that is just the way it works.  I could not find an OSS note.  Besides that, we are fairly current at 7.02 sp 09.

I guess SAP's perspective is that if you are editing a cell, how could you merge it.   Well, of course that only applies to cells that are editable.   You would like the ability to merge cells that are not editable.

Oh well. Too lazy I guess....  Operating as designed.

-Tim

[Former Member]

Yes as you mentioned I am not trying to merge the cell that are editable but I would like to merge the text fields in the other non-editable column to merge rather than repeating the same on each line.

but anyway thanks for your quick response.

Thanks,

Uday.

[Former Member]

I am also facing the same problem.

I really need the sorting and merging for my report to be readable and it also should be editable.

I guess I will have to use some work around to update editable field.    

[Former Member]

Hi George,

I was able to resolve this issue using the CL_GUI_ALV_GRID->SET_FRONTEND_LAYOUT( <INT>) method. To enable the grid for editing set the value to <INT> value to 1, to disable editing set the value to 0.

To me it is quite logical that you cannot have the grid in edit mode and use cell merge at the same time. You need to disable the editing as indicated and then merge the cells.

Ross.

[dkle]

Hi Ross,

this is not about setting the whole grid in edit mode, but single columns!

Merging is not possible if a single column is in edit mode.

@all

I will raise an OSS message for this under component BC-SRV-ALV and will notify you about the results.

[dkle]

Here is the answer of SAP:

Dear Customer,
The cell-merging doesn't work in the editable grid for technical reasons
and I also have to inform you, that the usage of the editable ALV grid
is not supported at the moment and may lead to unpredictable results.
Please have a look at OSS note:
695910 ALV grid: Editable grid and non-released methods
Please also note that REUSE_ALV_GRID_DISPLAY is only released internally
(like other REUSE* FM)
You can see that info in the attribute part of the function module in
SE37. You should therefore not be programing with it.
I would recommend you to take a look at class CL_GUI_ALV_GRID to use in
your custom report as a possible alternativeto the REUSE* FM
Please note this is likely be considered remote consulting rather than
support.

[Former Member]

Hello, anyone found a solution to this problem?

Thanks.