Macros/Calc/py001/da
Outdated translations are marked like this.
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Beskrivelse
Kopiér indholdsceller fra et regneark til et andet. Kilderegnearket skal være åbent.
Python-kode
import uno
from com.sun.star.table.CellContentType import TEXT, VALUE
</div>
def copy_cell():
doc_source_name = 'source.ods'
sheet_source_name = 'source'
cell_source_name = 'A1'
desktop = XSCRIPTCONTEXT.getDesktop()
for doc_source in desktop.Components:
if doc_source.Title == doc_source_name:
break
cell_source = doc_source.Sheets[sheet_source_name][cell_source_name]
doc = XSCRIPTCONTEXT.getDocument()
cell = doc.CurrentController.ActiveSheet[cell_source_name]
if cell_source.Type == TEXT:
cell.String = cell_source.String
elif cell_source.Type == VALUE:
cell.Value = cell_source.Value
else:
cell.Formula = cell_source.Formula
return