Hello
I have a workbook and it's address is C:\Yetki.ods ; I need some cell comments from this workbook; and I will put these comments to another workbook's cells.
Is there any way to get some cell values/Comments from another workbook without open it?
For example I want to get cell(1,1)'s comment.
I couldn't refer the other book, I don't know how to.
We have formulas but that doesn't bring cell comments.(annotations)
Thank you anyway.
Get Cell Values/Comments from Another Workbook(Offline)
-
- Posts: 4
- Joined: Mon Nov 05, 2012 9:46 am
Get Cell Values/Comments from Another Workbook(Offline)
OpenOffice 3.3 on Windows 7
Re: Get Cell Values/Comments from Another Workbook(Offline)
[Tutorial] External Links In Calc. Spreadsheets operate on cell values only. All the other elements are illustration and decoration.
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
Re: Get Cell Values/Comments from Another Workbook(Offline)
And After using external links then (maybe) we can use a user-defined function.
This function returns the comment of equis cell.
=COMENTARIO("SheetName";"D4")
This function returns the comment of equis cell.
=COMENTARIO("SheetName";"D4")
Code: Select all
Function Comentario(Hoja, celda)
oDoc = ThisComponent
hojas = oDoc.getSheets()
oSheet = hojas.GetByName(hoja)
oCell = oSheet.getCellRangeByName(celda)
oCmt = oCell.getAnnotation()
oCmtStr = oCmt.getString()
Comentario = oCmtStr
End Function
lo 5.1.6.2 | aoo 4.1.3 | win 7/10
All I know is that I know nothing
All I know is that I know nothing