LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-03-2017, 10:03 PM   #1
johnpham
LQ Newbie
 
Registered: Feb 2017
Posts: 3

Rep: Reputation: Disabled
I need an id or date column in LOCalc!


I need a way to pin a unique id to every line in a LibreOfficeCalc sheet. A simple date file (yyyy_mm_dd) or a four place number (or,better, both) would be ideal, but it needs to stick with the data in the line it is in even through sorting procedures, or when a new line is added. And it should be added automatically when a line is added. And it would help if it could change when any cell in the line is changed.

I have searched the internet for an answer, and find nothing that I can understand, or even that I can be sure applies to the problem.


------------------------------------------
top ringtones, mp3 ringtones download, loud ringtones

Last edited by johnpham; 02-14-2017 at 10:32 PM.
 
Old 02-04-2017, 09:40 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 23,953

Rep: Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029Reputation: 7029
Quote:
Originally Posted by johnpham View Post
I need a way to pin a unique id to every line in a LibreOfficeCalc sheet. A simple date file (yyyy_mm_dd) or a four place number (or,better, both) would be ideal, but it needs to stick with the data in the line it is in even through sorting procedures, or when a new line is added. And it should be added automatically when a line is added. And it would help if it could change when any cell in the line is changed.

I have searched the internet for an answer, and find nothing that I can understand, or even that I can be sure applies to the problem.
Read the "Question Guidelines" link in my posting signature. You don't say what version/distro of Linux you're using, or what version of Libreoffice...and this is really a Libreoffice question, not so much a Linux question.

But, the Libreoffice documentation has much on how to do this, which was found with a brief Google search:
https://help.libreoffice.org/Calc/Au...ulating_Series

Since you don't tell us what you've looked at, what you don't understand/have done/tried, etc., we can't really guess as to how to help.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
I need an id or date column in LOCalc littlejoe5 Linux - Software 2 12-26-2016 09:26 PM
[SOLVED] How to sort file with date column? santosh0782 Linux - Newbie 11 05-28-2014 11:37 PM
[SOLVED] replace the nth column date as MM/DD/YYYY anshaa Linux - Newbie 1 08-13-2012 04:25 AM
LXer: How to change Thunderbird's date format in Date column LXer Syndicated Linux News 0 07-18-2012 02:11 AM
Open Office year-to-date column Stragonian Linux - Software 1 04-13-2010 12:36 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 11:43 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration