Bug 101808 - no option to set length in settings of cells as TEXT
Summary: no option to set length in settings of cells as TEXT
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Number-Format Cell-Validity
  Show dependency treegraph
Reported: 2016-08-30 22:41 UTC by Davide
Modified: 2019-02-16 07:54 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Davide 2016-08-30 22:41:40 UTC
CALC: it is not possible in the setting of cells as TEXT make available the setting's options about length of the text cell?

For example:

abbreviation province text "@!!" (Accepts only 2 letters) 

example MI (abbreviation province MIlan)

@"00!!00" (accepts two numbers, two capital letters, two numbers), Example 25WV02

@"!!!!!!00!00!000!"  italian tax code
Comment 1 m.a.riosv 2016-08-31 22:31:27 UTC
You can do validations with Menu/Data/Validity, where i.e. you can fix a text length, but not a mask.

There is a pattern field on Forms Toolbar - More controls, but it can't be linked to a cell directly in a spreadsheet. Maybe registering the table spreadsheet as database could be a way.

But not a bug. If you want a request for enhancement, if so, please change the second field of importance to 'enhancement'
Comment 2 Davide 2016-09-01 20:17:42 UTC
Yes I know. Now I use validations (Menu/Data/Validity)

A mask could allow the possibility of setting text or text+numbers

It can't be done from Forms Toolbar - More controls

It's not a bug but it's an enhancement/improving/implementation
Comment 3 Cor Nouws 2016-09-03 10:09:02 UTC
let's set as enhancement yes. Thanks Davide and Miguel for explaining and discussing