Address above problem has been solved, now I want to solve is how those rows cannot edit, and change the line color, how to solve?
For example: the name of the course code course budget
5001 business spending has been calculated (make an edit and change the background color)
500101 financial aid spending has been calculated (make an edit and change the background color)
50010101 basic spending has been calculated (make an edit and change the background color)
5001010101 salary welfare spending has been calculated (make an edit and change the background color)
500101010101 basic salary 1000
500101010102 XXXXXXX 1500
500101010103 XXXXXXX 1800
Int k, li_find
Long ll_total, ZXHJ
String ls_kmdm, ls_kmdmA
For I=dw_1. RowCount () To Step 1-1
Ls_kmdm=Trim (dw_1. The Object. The subject code [I])
Ls_kmdmA=Left (ls_kmdm, Len (ls_kmdm) - 2)
Li_find=dw_1. Find (' subject code="' + ls_kmdmA +" ', 1, dw_1, RowCount ())
If li_find & gt; 0 then
For k=li_find to dw_1. Rowcount ()
If Left (Trim (dw_1. The Object. The subject code [k]), Len (Trim (dw_1. The Object. The subject code [k])), 2)=Trim (dw_1. The Object. The subject code [li_find]) then
Ll_total +=dw_1. Object. Budget [k]
Dw_1. Modify (" budget. Protect='1 ~ t the if (Left (course code [" + string (k) + "], Len (subject code [" + string (k) + "]), 2)=subject code [" + string (li_find) + "], 1, 0)' ")//* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
End the if
Next
End the if
Dw_1. SetItem (li_find, "budget", ll_total)
Ll_total=0
Next
Subject code rules - 4-2-2,,,,,,,, there is a line of asterisks somehow change? I make these lines do not edit
CodePudding user response:
CodePudding user response:
. Column name. Protect property and column names. The background color attribute can be written as expressionCodePudding user response:
With reference to the upstairs · · · · · · · · · · · · · · · · · · · · · ·CodePudding user response: