import { Button, Input, InputNumber, Select, Spin } from 'antd'; import React, { useState } from 'react'; const { Option } = Select; function PsrControl(props) { const { sheetRef } = props; const [value1, setValue1] = useState(0.15); const [value2, setValue2] = useState(0.25); const [value3, setValue3] = useState(14096800); const [loading, setLoading] = useState(false); const changeProjectType = type => { sheetRef.current.luckysheet.setCellValue(101, 1, type, { order: 0, }); sheetRef.current.luckysheet.setCellFormat(101, 1, 'ct', { fa: 'General', t: 'g' }); sheetRef.current.luckysheet.refreshFormula(); }; const changeBiddingType = type => { sheetRef.current.luckysheet.setCellValue(102, 1, type, { order: 0, }); sheetRef.current.luckysheet.setCellFormat(102, 1, 'ct', { fa: 'General', t: 'g' }); sheetRef.current.luckysheet.refreshFormula(); }; const goalSeek = (type, value) => { setLoading(true); try { sheetRef.current.goalSeek(type, value); } catch (error) {} setLoading(false); }; return (