FORECAST.LINEAR Formula is not Working for me

justkawal / excel

Excel Library for Flutter and Dart - https://pub.dev/packages/excel

MIT License

403 stars 212 forks source link

FORECAST.LINEAR Formula is not Working for me #308

Open sahil-wappnet opened 6 months ago

sahil-wappnet commented 6 months ago

String formulaForPrediction = 'FORECAST.LINEAR(A${listLen+2},C2:C${listLen+1},A2:A${listLen+1})'; CellIndex cellIndex= CellIndex.indexByColumnRow(columnIndex: 2,rowIndex: (listLen+1)); sheet.cell(cellIndex).setFormula(formulaForPrediction.toUpperCase());

And after Saving that file into my local Storage and open in to my system and just change the formula text from small to Capital it starts working but i want to Perform the same Operation using Command / Code

justkawal commented 6 months ago

Sorry, for issues in this library, I'm doing some structure changes in my local repo and would be releasing soon. Again sorry for the issues.... I'm trying my best to keep this project alive while searching for the jobs.

Thanks for understanding. Much appreciated.