excel-export | excel-export grails

I have a website served by express running on AWS Elastic Beanstalk, Node.js 14. Login and everything works fine on Chrome, but on Firefox I get window.openDatabase is not a function and on Safari I get web sql is deprecated when I try to login. Website: https://www.portapay.xyz/login. I am currently not building for production; how I build: ng build --configuration development. I have made sure that all of my browsers are up to date and have the latest version. None of the code I wrote uses window.openDatabase or executeSql. I only connect to a MongoDB with Kinvey's SDK. I do not use Cordova.

browserlistrc

I am using ag-grid enterprise version in typescript react application. It works perfectly fine but when I add the below line to implement the detailed grid feature, it is throwing compilation error as mentioned below.

I'm facing a problem and I can't find a solution for it. I make a couple auf AJAX requests in my project and all work fine. But now, this AJAX request (build as the other ones) doesn't work.

jQuery AJAX Request

We have a solution that converts an ActiveReport based report into an Excel file. Basically that works very fine, but in some environments for some very strange reason the downloading of the Excel file doesn't start and the Excel file opens on a web browser window instead of asking if the user wants to open or save the generated Excel file.

Our application is running on a Windows Server 2019 based virtual machine. However, if I connect to the web server on that virtual machine from other computer and open the same application and export the same report into an Excel file everything works fine. The web browser asks if I want to save or open the Excel document and I can open that fine to Excel or Excel viewer.

One more strange thing is, that this problem doesn't appear in every server running this same application. It also seems, that if there is only Microsoft Office Excel viewer installed on the server, these problems appear - not in every case though. If full version of Excel is installed, it seems, that there are no problems.

We have tried everything what we have found. We have set the browser flags ( https://docs.microsoft.com/en-US/troubleshoot/browsers/how-to-set-ie-to-open-office-documents-in-office-program and https://www.thewindowsclub.com/make-internet-explorer-open-linked-office-documents-in-the-appropriate-office-program ) and went through dozens of web pages and reinstalled Excel Viewer.

Still, it seems that this problem is not related to browser flags at all, since this works fine in other servers even the browser flag values are not set in registry keys.

So, to me the problem seems to be in web browser settings on the server. I just cannot imagine where. The web browser installed on the server is IE 11.

Any help is highly appreciated.

EDIT:

As I explained in my comment I discovered, that there are differences in versions of this application where this problem occurred.

The differences between versions are:

I am using angular slickgrid to show my data. I monitoring the data continuously. If any changes happened in server side, that data need to update in application. So that modified data updated in slickgrid by this code this.angularGrid.gridService.updateDataGridItem(data);. While updating data, the angular slickgrid fully rendered for multiple times. I want avoid angular slickgrid multiple times rendering.

Current behavior

While adding or updating a record, angular slickgrid renders multiple time

Expecting behavior

While adding or updating a record, angular slickgrid needs to update the particular row dataview only

Here i shared my gridoptions for your reference.

I'm using Kendo UI for Angular and I'm currently trying to make a simple Grid to work.

Here's my code :

I got this error after installed 'angular-in-memory-web-api'.

import { InMemoryDbService } from "angular-in-memory-web-api";

and I got these error

ERROR in node_modules/angular-in-memory-web-api/backend.service.d.ts(18,19): error TS1086: An accessor cannot be declared in an ambient context.

This is my packge.json

Recently i moved my angular application in some different folder. since then when i want to build the app i get this error:

Schema validation failed with the following errors: Data path "" should have required property 'tsConfig'

I tried to look up in github and stackoverflow and only found these links:

https://github.com/angular/angular-cli/issues/11479

they say i have to downgrade a package:

"@angular-devkit/build-angular": "^0.800.1" to "^0.12.4"

but this don't feel like the right way

I'm using grails-excel-export plugin to export data into an Excel (in xlsx format), but I'm having issues when opening the file with Microsoft Office (no problems with OpenOffice).

When I open it, I get the message "We found a problem with some of the content in 'exportedFile.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes", same as this one:

I've already found out that the problem comes only when applying any kind of cellstyle to the workbook, in my case I'm to set bold the first row.

This is the code: