hey all,
i'm trying to access cell so that i can add a user defined attributes to the cell such that i can access each cell uniquely..
can anyone help me out ..!!
thanks..
Working with Cell properties in Calc
Working with Cell properties in Calc
open office 4.1.1
Windows 7
Windows 7
-
- Posts: 351
- Joined: Sat May 24, 2008 6:59 pm
Re: working with Cell properties in calc
The only potentially unique thing about a cell is its absolute address. Often attributes / formatting is used on more than one cell.
OOo 4.1.1. bld 9593 on MS Windows 10 64 SP1 Chillblast fusion i5 and Acer Aspire E1-572 Laptop
There's got to be a better way
And for all accountants - The change is coming
There's got to be a better way
And for all accountants - The change is coming
Re: working with Cell properties in calc
menu:Insert>Names>Define...
or simply type some name into the name box left of the formula bar.
or simply type some name into the name box left of the formula bar.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- MrProgrammer
- Moderator
- Posts: 5282
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: working with Cell properties in calc
I don't understand what you are trying to accomplish, but spreadsheet cells do not have user-defined attributes. However, you can create additional sheets, which you could even hide with Format → Sheet → Hide, where you can store additional information. Two attributes for cell Sheet1.D5 could be stored in Sheet1X.D5 and Sheet1Y.D5. Use relative references to address the attribute cells in the additional sheets so your formulas adjust automatically when they are copied. Read section 8. Using formulas and cell references in Ten concepts that every Calc user should know.vikash wrote:i'm trying to access cell so that i can add a user defined attributes to the cell such that i can access each cell uniquely.
If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Edit: 2024-05-09: Calc functions and builtin features cannot create user defined attributes in a cell. But a macro can. [Solved] UserDefinedAttributes property of Calc cell |
Last edited by MrProgrammer on Fri May 10, 2024 4:09 pm, edited 2 times in total.
Reason: Add new information about macros
Reason: Add new information about macros
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.6, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.7.6, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).