Values change even for unselected items

[MKVRC]

Values change even for unselected items

In the attached excel sheet, under description column there are 4 items by name: ABC, BCD QAZ & XYZ

Sample.xlsx

(9.05 KiB) Downloaded 534 times

Issue what I am facing is something like as follows:

I have put an auto filter and then did select ABC from the Description (Column B) -> this listed all the items having name ABC -> then I changed the “Price (Column C)” for these alone to 111. First i select 1st row in C2, change its value to 111 and then select remaining cells with name ABC and copy paste the value 111.

Ideally expected is value should be changed only for the items having name ABC but to my surprise value (111) was changed even for other items with name BCD & QAZ

When used same excel with MS excel did not face any issues and worked as expected!

Could you please look into this bug and suggest a solution at the earliest? Thanks

PS: reported issue/bug can be seen with both Softmaker free office 2021 and SoftMaker Office 2024