It is not possible to specify a negative time

justkawal / excel

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

MIT License

403 stars 212 forks source link

It is not possible to specify a negative time #316

Open amedeop opened 5 months ago

amedeop commented 5 months ago

It is not possible to specify a negative time, as "-3:12" (useful, for example, for managing hourly accounting). Error: Assertion failed: file:///[...]/.pub-cache/hosted/pub.dev/excel-4.0.2/lib/src/sheet/data_model.dart:264:16 hour >= 0 is not true

amedeop commented 5 months ago

There is an additional problem: you cannot specify a value greater than 23:59, otherwise you will get an invalid result. For example, entering 25:00 results in 02/01/1900 01:00.