array(4 items)
   caller => 'TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery' (60 chars)
   ERROR => 'Unknown column '_LOCALIZED_UID' in 'field list'' (47 chars)
   lastBuiltQuery => 'SELECT uid,pid,content_uid,title,description,fal_image,link,textposition,sty
      leclass,tstamp,crdate,cruser_id,deleted,hidden,starttime,endtime,t3ver_oid,t
      3ver_id,t3ver_wsid,t3ver_label,t3ver_state,t3ver_stage,t3ver_count,t3ver_tst
      amp,t3ver_move_id,sorting,t3_origuid,sys_language_uid,l10n_parent,l10n_diffs
      ource,_LOCALIZED_UID FROM tx_wsflexslider_domain_model_image WHERE pid=-1 AN
      D t3ver_oid=352 AND t3ver_wsid=0 AND tx_wsflexslider_domain_model_image.dele
      ted=0 LIMIT 1
' (469 chars) debug_backtrace => '{closure}#34 // TYPO3\CMS\Frontend\Http\Application->run#33 // TYPO3\CMS\Cor
      e\Core\Bootstrap->handleRequest#78 // TYPO3\CMS\Frontend\Http\RequestHandler
      ->handleRequest#311 // TYPO3\CMS\Frontend\Page\PageGenerator::renderContent#
      216 // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGet#210 /
      / TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#805
      // TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->render#859 // TYP
      O3\CMS\Frontend\ContentObject\TemplateContentObject->render#943 // TYPO3\CMS
      \Frontend\ContentObject\ContentObjectRenderer->cObjGetSingle#130 // TYPO3\CM
      S\Frontend\ContentObject\ContentObjectRenderer->render#859 // TYPO3\CMS\Fron
      tend\ContentObject\ContentContentObject->render#943 // TYPO3\CMS\Frontend\Co
      ntentObject\ContentObjectRenderer->cObjGetSingle#97 // TYPO3\CMS\Frontend\Co
      ntentObject\ContentObjectRenderer->cObjGetSingle#841 // TYPO3\CMS\Frontend\C
      ontentObject\ContentObjectRenderer->render#859 // TYPO3\CMS\Frontend\Content
      Object\CaseContentObject->render#943 // TYPO3\CMS\Frontend\ContentObject\Con
      tentObjectRenderer->cObjGetSingle#44 // TYPO3\CMS\Frontend\ContentObject\Con
      tentObjectRenderer->cObjGetSingle#841 // TYPO3\CMS\Frontend\ContentObject\Co
      ntentObjectRenderer->render#859 // TYPO3\CMS\Frontend\ContentObject\FluidTem
      plateContentObject->render#943 // TYPO3\CMS\Frontend\ContentObject\FluidTemp
      lateContentObject->renderFluidView#102 // TYPO3\CMS\Fluid\View\AbstractTempl
      ateView->render#300 // FluidCache_Standalone_layout_HeaderContentFooter_2a81
      d5eab37923b17f062118145e31540222992a->render#189 // TYPO3\CMS\Fluid\ViewHelp
      ers\RenderViewHelper::renderStatic#63 // TYPO3\CMS\Fluid\View\AbstractTempla
      teView->renderSection#121 // FluidCache_Standalone_template_file_List_60beed
      5e52fafc03df4ca0aaf63d338ce48a889c->section_040f06fd774092478d450774f5ba30c5
      da78acc8#230 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelper->initiali
      zeArgumentsAndRender#47 // TYPO3\CMS\Fluid\Core\ViewHelper\AbstractViewHelpe
      r->callRenderMethod#249 ...
' (4717 chars)
How to restrict editing in Excel forms in workflow tasks

Tutorial: How to restrict editing in Excel forms in workflow tasks

When using an Excel worksheet in a workflow collaboratively, you may want to make sure that parts of the worksheet can be edited (e.g., to add information) only by particular users or roles when doing particular tasks. This is for example needed, when you want to use one part of the worksheet to collect information and another part for a supervisor to assess the collected information. In this case, you may want to make the assessment part of the Excel form editable only to the supervisor users when doing the assessment in the workflow.

Solution

In Spreadsheet Router, you can select cells and parts of the Excel worksheet that are relevant and can be edited for each task of your workflow. During workflow execution, Spreadsheet Router ensures that only the specified cells and parts of the worksheet are editable when conducting the respective task. All other cells are ready-only and cannot be changed by the workflow user.

Thus, each user / role can be assigned parts or cells in the Excel worksheet that are relevant this user's / role's tasks. This prevents errors and ensures data integrity. Watch our video tutorial to see how it works.


Excel-Bereiche zur Eingabe freischalten

 

 


Youtube Video: Spreadsheet Router Tutorial: Excel-Bereiche zur Eingabe freischalten

About the Author

Inna Grünwald

More posts by this author