asked 2012-10-01 16:26:03 +0200

Lula
1

5693 ● 3 ● 48 ● 41

Olá, Preciso criar uma identificação automática de registros em cada linha de uma planilha calc já existente, tipo uma célula contendo ID0001, ID0002, ID0003, ID0004, etc.... em cada linha da planilha. Isto é possível? Agradeço as contribuições. Ats,

delete close flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

answered 2012-10-01 16:32:28 +0200

JohnSUN

2338 ● 2 ● 23 ● 36
http://wmstrong.ru/

updated 2013-01-31 08:41:36 +0200

Você quer dizer = "ID" & TEXT(ROW (); "0000")?

For those who do not understand Portuguese, but can be read in English:

Q: Hello, I need to create an automatic identification of records in each row of an existing calc spreadsheet, type a cell containing ID0001, ID0002, ID0003, ID0004, etc... in each row of the spreadsheet. Is this possible?

A: Did you mean ="ID" & TEXT(ROW(), "0000")?

link delete flag offensive edit

Comments

Hi @JohnSUN, Could you provide an English summary of this question? If I understand it a bit better, I can resolve it. Thanks!

qubit ( 2013-01-31 07:24:33 +0200 )edit

@qubit Done

JohnSUN ( 2013-01-31 08:42:29 +0200 )edit

Resources

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Stats

Asked: 2012-10-01 16:26:03 +0200

Seen: 32 times

Last updated: Jan 31

Incluir linhas de ID no Calc