brainfoolong
Repos
32
Followers
48
Following
2

CryptoJS 3.x AES encryption/decryption on client side with Javascript and on server side with PHP

321
151

Better Battlelog legacy code and legacy website. It was fun :)

30
12

A zero dependency, cross browser library to easily get or set/manipulate form input values as/from a json object.

40
7

Optimized fuzzy omnibox history search for chrome - Like firefox quick history search

12
5

Events

update to allow integrated appdata as well as mapped appdata

Created at 3 hours ago

added new repository dispatch

Created at 8 hours ago
delete branch
brainfoolong delete branch v2
Created at 8 hours ago

merged v2 into main branch

Created at 8 hours ago

refactoring from docker-compose to a single dockerfile

refactoring from docker-compose to a single dockerfile

refactoring from docker-compose to a single dockerfile

refactoring from docker-compose to a single dockerfile

refactoring for a new docker way

refactoring for a new docker way

refactoring for a new docker way

refactoring for a new docker native way (no compose)

refactoring for a new docker native way (no compose)

refactoring for a new docker native way (no compose)

refactoring for a new docker native way (no compose)

refactoring to new configs, docker and general improvements upgraded a lot of dependencies this commit breaks compatibility with all older versions

updates for better debugging in git actions

removed now deprecated app update checks optimized console.php calls removed unused docker env vars

colorize output

more verbose information for mariadb start less clutter with messages

added useful scripts to build updated setups, so they wait until everything is fine

added more useful scripts

added framelix_php script that correctly uses the nginx user instead of always root

added framelix_php script that correctly uses the nginx user instead of always root

Created at 8 hours ago

make unit tests instance self setup with a default user added support for key/value in lang file (instead of value need to be an array) fixed modal window js errors

fixed toast js error when message is missing

design updates for sidebar for better visibility

Created at 9 hours ago

updates readme infos

Created at 14 hours ago

updates readme infos

Created at 14 hours ago

updates readme infos

Created at 14 hours ago

fixed wrong chmod on setup

Created at 14 hours ago

fixed unit tests

Created at 14 hours ago

fixed unit tests

Created at 15 hours ago

fixed unit tests code reformat to psr standards added new config flag $appSetupDone instead of relying on 01-core config file

Created at 15 hours ago

fixed unit tests code reformat to psr standards added new config flag $appSetupDone instead of relying on 01-core config file

Created at 15 hours ago

fixed unit tests code reformat to psr standards added new config flag $appSetupDone instead of relying on 01-core config file

Created at 15 hours ago

added framelix_php script that correctly uses the nginx user instead of always root

added framelix_php script that correctly uses the nginx user instead of always root

Created at 16 hours ago

added framelix_php script that correctly uses the nginx user instead of always root

Created at 16 hours ago

fixes for unittests

Created at 1 day ago

fixes for unittests

Created at 1 day ago

refactored FramelixApi.callPhpMethod to FramelixRequest.jsCall

added more testes for better coverage removed deprecated functions in forms

Created at 1 day ago

refactored FramelixApi.callPhpMethod to FramelixRequest.jsCall

added more testes for better coverage removed deprecated functions in forms

Created at 1 day ago
issue comment
CellRange trimmed if from and to is equal, result in auto filter errors

Great. Thanks for your replies.

Created at 1 day ago
issue comment
CellRange trimmed if from and to is equal, result in auto filter errors

Ok, i understand. So, what is your advice on how i should do it? Should i do it, the way i do, defining a range E4:E4 by hand, to overcome the check in autofilter?

Created at 1 day ago
issue comment
CellRange trimmed if from and to is equal, result in auto filter errors

I have also tested in my excel, and no errors appear when using a filter settings for that. Is auto filter in phpspreadsheet not just doing that?

See animation:

screeny

Created at 1 day ago
issue comment
CellRange trimmed if from and to is equal, result in auto filter errors

Hm. Ok. That *byColumnAndRow() is deprecated is new to me. Seems that PhpStorm doesn't check that when @Depreceted where it's D is uppercase. Werid :)

Thanks for that excel info. Our internal use cases and codes always only used setAutoFilter with a single row and 1 or X columns. So we can have zero or more rows after.

So we have, for example, to mark row 1 as auto filter, with given numer of columns:

setAutoFilterByColumnAndRow(1, 1, 1, 1);
setAutoFilterByColumnAndRow(1, 1, 3, 1);
setAutoFilterByColumnAndRow(1, 1, 9, 1);

This always worked perfectly fine. However, the case with only one column is indeed pretty rare and can only be when user do some weird settings on the reports. But we never provide more then one row...

Are we doing this wrong, ever since? We have hundreds of phpspreadsheet reports using it like that.

Created at 1 day ago
issue comment
CellRange trimmed if from and to is equal, result in auto filter errors

It created that for the user, which is pretty handy, even on a single column.

image

Created at 1 day ago
issue comment
CellRange trimmed if from and to is equal, result in auto filter errors

Thanks for answer. To provide a interface where the user can filter, sort, etc... without the need to do anything. It's valid for just one column, or more. Anyway, a single cell works when using setAutoFilter, it's just not working with setAutoFilterByColumnAndRow.

Created at 1 day ago
CellRange trimmed if from and to is equal, result in auto filter errors

This is:

- [x] a bug report

I have found this line: https://github.com/PHPOffice/PhpSpreadsheet/blob/88bbac9849cea9642c874e6ca2bd29ee81f99910/src/PhpSpreadsheet/Cell/CellRange.php#L127

Which effectively convert a range into a single cell, which then causes errors in other functions that explicitely require a range cell name, even of the range consists of just one field.

So the result is, i cannot set AutoFilter with a range of one cell and it will throw an error

Cell get's converted here (__toString is called): https://github.com/PHPOffice/PhpSpreadsheet/blob/88bbac9849cea9642c874e6ca2bd29ee81f99910/src/PhpSpreadsheet/Worksheet/Validations.php#L32

Error thrown here https://github.com/PHPOffice/PhpSpreadsheet/blob/88bbac9849cea9642c874e6ca2bd29ee81f99910/src/PhpSpreadsheet/Worksheet/AutoFilter.php#L127

Filter isset with: https://github.com/PHPOffice/PhpSpreadsheet/blob/88bbac9849cea9642c874e6ca2bd29ee81f99910/src/PhpSpreadsheet/Worksheet/Worksheet.php#L2143

The current workaround is to use setAutoFilter instead of setAutoFilterByColumnAndRow and providing a string range.

Created at 1 day ago

added missing regex fix for case when options are provided

Created at 5 days ago
pull request opened
fixed regexp not properly escape windows backslash in path

Suddenly, my CLI stopped working when provided a file path on windows in npx playwright test c:\foo\bar\123. I tracked it down, that the cli runner forces a path to become a regex, if a string is given. But, for whatever reason (I don't see any relevant change here since a long time), this stopped working. If a path contains a backslash (so on windows), the regex never match, because a backslash need to be double escaped. Especially when you have number as filename in your path, it get's weird. Example: c:\foo\bar\3rdparty will become c:\foo\bar\x03rdparty in the regex, without escaping.

This change fix this behaviour. Also this works when providing already escaped backslashes in path.

Here is the regex test for it: https://regex101.com/r/W5QO7Q/2

I don't see why this has ever worked before, but maybe a TS compiler change or a NodeJs change in a recent version (i am on 16.17.0 now) caused this regex to no longer work.

Created at 5 days ago