| Summary: | field length cannot be changed | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Sandra Farnedi <sandra.farnedi> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED WONTFIX | ||
| Severity: | normal | CC: | chris |
| Priority: | medium | ||
| Version: | unspecified | ||
| Hardware: | x86 (IA32) | ||
| OS: | Linux (All) | ||
| See Also: | https://launchpad.net/bugs/986820 | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | the highlighted field is the one whose length I want to change but I can't | ||
Sandra Farnedi, as mentioned in https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/986820/comments/5 please do not slam 2 issues into one report. That applies here in upstream as well. Please file a new report, one issue per report. |
Created attachment 60449 [details] the highlighted field is the one whose length I want to change but I can't I'm defining a table in LibreOfficeBase containing an integer field. I cannot change the field length which is set to 10. Same problem with the following field types: TINYINT (3), BIGINT (19), REAL (17), DOUBLE (17), OTHER (2147489647). Moreover I notice that the following field types NUMERIC, DECIMAL, FLOAT, VARCHAR, VARCHAR_IGNORECASE, inherit the latest set length, that is: when I add a field it is set to VARCHAR (100), if I change it to FLOAT its length is automatically set to 17, if I come back to VARCHAR, the field length is not set back to 100, but still remains 17.