AzzaAzza69
AzzaAzza69
Sometimes value is as important as format for us. We have spreadsheets which we process and extract out half (data and format) and write these out along with some new...
PS. Does your recommendation of "But we do not recommend using these methods with large files" apply to just: ``` $sheet->readRowsWithStyles(); $sheet->readColumnsWithStyles(); $sheet->readCellsWithStyles(); ``` or does it also apply to:...
That's great. So if I use $excel->dateFormatter(true), how can I determine if a cell contains just a date, just a time or both a date and a time? Do I...
Most excellent, can I suggest that the categories for formats: 18-21 should be "time" 22 : "datetime" 45-47 : "time" and a tweak the _isDatePattern accordingly to recognise the three...
how about? // I guess you could not bother with the valid "number" of each letter, in which case a simple strpos for character $bHasTime=(preg_match('/h{1,2}|m{1,2}|s{1,2}|/(AM\/PM)|(A\/P)', $sPattern)===1); $bHasDate=(preg_match('d{1,4}|m{1,5}|y{2}|y{4}', $sPattern)===1); if($bHasDate &&...
Where a project folder has lots of sub-folders: /project/ /project/app/ /project/app/controllers/ /project/app/views/ /project/public/ /project/public/css/ /project/public/js/ /project/public/images/ /project/public/fonts/ /project/public/third-party/ I would like to have: { rootPath: "/project", paths: ['app/*', 'public/css/', 'public/js/'],...
After finding this: "Go to your settings, search for the grammar-selector package, then click on its settings button. Uncheck “Hide Duplicate Grammars.” Now you'll be able to click on the...
Its not doing it anymore (I have been working on the file) but the rest of the line is: ... } $this->q->param('prmManualType')->setString( (isset($o->manualType) ? $o->manualType : '') ); if($o->changeMode=='='){ $sSql.='...
I'd also mention (in case it is something to do with the above), that a yellow "1 Deprecation" has appeared in the status bar...which expands to: Deprecated calls atom core...
Just had it happen again...have been working on project for 20 mins, opened a .php file (2343 lines), wasn't coloured. Tried Ctrl+A, Ctrl+X, Ctrl+V ; no difference Closed tab, re-opened...