Created on 2021-11-19.13:14:22 by acaubet, last changed 3 months ago by ced.
File name | Uploaded | Type | Details |
---|---|---|---|
wdkLg47lMJM3Lhbu.png | acaubet, 2021-11-19.13:14:22 | image/png | view |
I do not know if it is possible to know that from the webbrowser.
remove the length for the temporary path where they will be stored.
IIUIC your solution it's only possible on Windows desktop client, not using sao as we can not know the temporary path. Am I right?
There is a possible improvement which will be that the client could set the upper limit for the filename of the report (in the context for example). This limit will be used instead of the default value if it is lower.
The client on windows will compute this limit by using the Microsoft limits and remove the length for the temporary path where they will be stored. If the computation result is 0 than the client will use the save popup instead of opening the file.
The best would be that this is only done if Microsoft software are used to open the file because I do not think libreoffice has such limit even on Windows.
Only for the record those are the limits:
https://docs.microsoft.com/en-us/office/troubleshoot/office-suite-issues/fails-opening-long-folder-name-files#more-information
There is no safe value as the problem is in Excel which has a limit on the fullpath.
We have found another client with the same problem.
I think the best option is to use a more save value, not so close to the limit as the actual.
A file of 175 chars as the first example provided is most of the time not relevant, because it's dificult to read.
So it is a limitation of Microsoft Excel and as the path on which the client will save the report can have any length, for me we can not fix anything here. It is probably better to use a better software than Microsoft Excel.
I could be related with https://support.microsoft.com/en-us/topic/error-message-when-you-open-or-save-a-file-in-microsoft-excel-filename-is-not-valid-951229f3-dc14-980f-765e-224e4fdc7331
As they mention the max length (path + filename) must be less than 219 chars.
The initial issue filename have 229 chars.
So we need to find why this OS does not support file name size of 200 which is really not that big (and lower than the common 255). An literature seems to suggest that the Windows limit is 260.
Does it work if it is smaller?
Yes, it works with REPORT_NAME_MAX_LENGTH = 100
Does other program can open it?
Not sure
Is the file format valid?
Yes, tested in other OS platforms.
Does it work if it is smaller?
Does other program can open it?
Is the file format valid?
After applying the issue10946 the name of the file is reduced but I keep receiving the following error attached on Excel:
Not found "C:\Users\BETA6\AppData\Local\Temp\tryton_r4hf0om\Entradas-y-salidas-de-clientes-100u-CTWOAD35MRB-Placa-Bloqueada-CTWO-35-M-Derecha-B-Acero-100u-IGRSSTA35-Gradilla-para-alquiler-tornillos-corticales-autorroscantes-35-Acero__1.xlsx". Check grammar syntax and check that the location is correct.
Any ideas?
History | |||
---|---|---|---|
Date | User | Action | Args |
2022-02-05 10:09:10 | ced | set | title: Error opening report -> Error opening report with Microsoft Excelwith long name |
2021-11-26 13:04:38 | ced | set | messages: + msg71877 |
2021-11-26 12:34:21 | acaubet | set | messages: + msg71875 |
2021-11-26 11:46:09 | ced | set | messages: + msg71872 |
2021-11-26 11:36:04 | acaubet | set | messages: + msg71871 |
2021-11-25 16:15:08 | ced | set | messages: + msg71859 |
2021-11-25 15:53:49 | acaubet | set | messages: + msg71858 |
2021-11-22 16:19:49 | ced | set | messages:
+ msg71780 status: need-eg -> chatting |
2021-11-22 15:56:30 | acaubet | set | messages: + msg71778 |
2021-11-22 14:07:28 | ced | set | messages: + msg71776 |
Showing 10 items. Show all history (warning: this could be VERY long)