1. C# / Говнокод #8889

    +118

    1. 01
    2. 02
    3. 03
    4. 04
    5. 05
    6. 06
    7. 07
    8. 08
    9. 09
    10. 10
    11. 11
    12. 12
    13. 13
    14. 14
    15. 15
    16. 16
    17. 17
    18. 18
    19. 19
    20. 20
    21. 21
    22. 22
    23. 23
    24. 24
    25. 25
    26. 26
    27. 27
    private Excel._Application _excel;
...
private void RefreshFormulas(FormulaRefreshOption formulaRefreshOption, object objectToRefresh)
		{
			//Где-то в дебрях километрового метода бросилось в глаза
                        ...
			try
			{
				Excel.Range intersection = selection, selection2 = selection;
				while (selection2 != null)
				{
					intersection = _excel.Intersect(selection2, selection2.Dependents,
						Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
						 Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
						  Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
						   Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);


					System.Windows.Forms.Application.DoEvents();
					excelUtilities.RecalculateRangeInstance(true, intersection/*_excel.Selection as Excel.Range*/);
					selection2 = intersection;
				}

			}
			catch (Exception) { /*ignore the exception because .Dependents will throw an exception if there aren't any dependents*/}
                        ...
		}

    Запостил: fade, 04 Января 2012

    Комментарии (4) RSS

    Добавить комментарий