Macros/Calc/py001
Jump to navigation
Jump to search
TDF LibreOffice Blog comunitari Weblate(traduci) Autori Nextcloud Redmine Ask LibreOffice | Donazione
Descrizione
Copia la cella del contenuto da un foglio di calcolo ad altro. Il foglio di calcolo originale dovrebbe essere aperto.
Codice Python
import uno
from com.sun.star.table.CellContentType import TEXT, VALUE
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