How to use, technical questions

This page introduces frequently asked questions about CELF usage and technology.

• [FAQ000001]How to paste a diagram on the sheet
• [FAQ000002]How to display today’s date in the calendar
• [FAQ000004]Can I create an import file of table definitions in Notepad?
• [FAQ000005]How do I register values to a newly created table in bulk?
• [FAQ000006]Is it possible to check all the input items at once before data registration?
• [FAQ000007]How do I operate the operational features (user management, group management)?
• [FAQ000008]When creating a screen for master registration, how can I check for duplicates?
• [FAQ000009]Is there a way to import CSV or text files?
• [FAQ000010]Is it possible to output reports?
• [FAQ000011]Is it possible to specify the sort order and number of data to be acquired?
• [FAQ000012]Is there any way to retrieve the current time?
• [FAQ000013]Can I change the definition of a table later?
• [FAQ000014]Is there something like a function list that summarizes the functions and specifications that can be used in CELF?
• [FAQ000015]Can I restore applications and sheets deleted with the trash icon?
• [FAQ000016]If I delete the app, will the tables remain?
• [FAQ000017]Is it possible to turn off the print and Excel output buttons in the upper right corner of the sheet screen?
• [FAQ000018] What is the difference between searching for all items and not searching for all items in the case of blank string in the table search condition?
• [FAQ000019]Can I attach files?
• [FAQ000020]What is the upper limit of the number of data to be retrieved from a table? Is it possible to limit it?
• [FAQ000021]The first 0 of the zip code is not displayed
• [FAQ000022]Can the results of a search done on Sheet 1 be displayed on Sheet 2?
• [FAQ000023]Can I set the default calendar value to no display?
• [FAQ000026]Can general users change their own passwords?
• [FAQ000028]How do I determine if a search result is OK or NG?
• [FAQ000029]Is it possible to prohibit the input of cells other than the input cells of a sheet?
• [FAQ000030]Is it possible to lock the app so that users cannot modify it without permission?
• [FAQ000031Is there some kind of macro function like in Excel?
• [FAQ000032]Can I change the table name later?
• [FAQ000033]Is it possible to duplicate the table definition and registration contents to create the same table with a different name?
• [FAQ000034]Can I change the name of the action set later?
• [FAQ000035]I don’t know how to delete an action that I added in the "Action Set" configuration screen.
• [FAQ000036]What fonts can I use with CELF? Can I use foreign characters?
• [FAQ000037]Is it possible to display barcodes with CELF?
• [FAQ000038] Can I not create a view?
• [FAQ000039]When connecting to Oracle externally, what is the extent of the table list that can be viewed?
• [FAQ000040]Can I connect to my own database via ODBC in the trial version?
• [FAQ000043]Is it possible to check for invalid data in the input form?
• [FAQ000045]Is there an expiration date for user passwords?
• [FAQ000046]Is it possible to specify vertical writing for cell strings?
• [FAQ000047]Is it possible to set a key to a table?
• [FAQ000048]Is there a function like the pivot table function in Excel?
• [FAQ000049]Is there a limit to the number of nested "If" in a CELF action?
• [FAQ000050]Is there any way to display row and column heading on a published sheet?
• [FAQ000051]When using the print function, is it possible to adjust margins, scaling, etc.?
• [FAQ000052]Other than the video instructions, are there any PDF instructions?
• [FAQ000053]Is it possible to call a sheet by the sheet name in the cell?
• [FAQ000054]I want to display the value of any cell in a pop-up message
• [FAQ000055]I want to launch CELF as a different user than the one who executed the CELF installer, but there is no shortcut.
• FAQ000057]Are multiple languages supported
• [FAQ000058]How do I migrate my apps, sheets, and tables to a new evironment (production environment)?
• [FAQ000059]When I start CELF, the error "Privileges are not set." appears
• [FAQ000060]The shortcut icon for CELF has not been created, how can I create it?
• [FAQ000061]When I try to login to CELF, an HttpException error appears
• [FAQ000062]the dialog to create a CELF shortcut at the end of CELF installation does not appear
• [FAQ000063]During CELF installation, the "This package may have a problem" error occurs
• [FAQ000064]When I renamed the CELF shortcut, the icon changed to a white icon
• [FAQ000065]When I booted up my PC, all the icons of CELF shortcuts had changed
• [FAQ000066]The error "The Curl runtime cannot write to the security options file" appears
• [FAQ000067]If I uninstall CELF, will it have any effect on the CELF applications that I have already created?
• [FAQ000069]Is there a way to import Excel content (data) onto a CELF sheet?
• [FAQ000070]What should I specify for the "reference type" and "[reference format]" in the argument of the ADDRESS function?
• [FAQ000071]Why are the column names in the "Table Management" screen displayed only halfway?
• [FAQ000072]What is the difference between the test run in the "Action set settings" screen and the test run in the sheet editing ribbon?
• [FAQ000073]Why doesn’t the "Quit Action Set" action quit the action when I run it?
• [FAQ000074]is it possible to output the "List of tables" of the "Table management" screen as CSV?
• [FAQ000075]Is it possible to prevent buttons and checkboxes from being printed?
• [FAQ000076]Can the window color be set by the system administrator?
• [FAQ000077]Can I hide the formula bar?
• [FAQ000078]Is it OK to use a different middleware from the specified version in the on-premise version of CELF?
• [FAQ000079]Can I connect directly to the default database of the cloud version of CELF?
• [FAQ000080]Excel files exported from CELF may be corrupted when opened
• [FAQ000081]How do I export or import a table definition?
• [FAQ000082]What happens if I reply to "no-reply@celf.jp"?
• [FAQ000083]Is it possible to automatically output the contents of an action set as a design document?
• [FAQ000084]When importing table data, the message "Specified file is not compatible with the field. Please check the file." appears
• [FAQ000085]When importing table data, the message "An error has occurred when registering the Xth data. Please check the file." appears
• [FAQ000086]Is it possible to delete all data in a table at once?
• [FAQ000087]The message "Session has timed out because of extended period of inactivity." appears
• [FAQ000088]Are the filters not reflected in the exported Excel file?
• [FAQ000089]The message "After multiple login failures, login is disabled for some time. Please login again after a while." appears
• [FAQ000090]The values registered in the table are different when checked in the table management screen
• [FAQ000091]Can I add a line break to a pop-up message?
• [FAQ000092]What SQL statements can be used in SQL Actions?
• [FAQ000093]How do you use the contents of a cell as a search condition for "matches one of the following"?
• [FAQ000095]What is the "Button ID" argument of the BUTTON function?
• [FAQ000096]Is it possible to show the file path and open it as a link?
• [FAQ000097]Can I use the same shortcut keys in CELF as in Excel?
• [FAQ000098]Is there any help or guide for the extension options?
• [FAQ000099]Can I view a website from a URL on a CELF sheet?
• [FAQ000100]How do I uninstall CELF?
• [FAQ000101] The message "User ID or password is wrong." appears
• [FAQ000102]The message "Failed in connecting to specified database" appears
• [FAQ000105]When connecting to an external database using an ODBC connection, the message "Failed in connecting to specified database." appears
• [FAQ000106]When setting an action set for the copied button, the settings of the original button also changed
• [FAQ000107]Can I change a button associated with one action set to another action set?
• [FAQ000108]Is it possible to select a drop-down list by keyboard operation?
• [FAQ000109]Is it possible to save multiple sheets of CELF as a single book?
• [FAQ000110]When attempting to save a file to a particular file, it failed
• [FAQ000111]When installing CELF, the message "Unable to connect to the server (12029)" appears
• [FAQ000112]Can I dynamically set the calendar and check buttons to a desired location?
• [FAQ000113]The message "Cannot paste because the size of the copy area is different from the paste area." appears
• [FAQ000114]Can I change the source of the email sent by the "Send email" action?
• [FAQ000115]How do I change the name of the app I created?
• [FAQ000116]How can I exclude cells with formulas set in the cross tabulation?
• [FAQ000117]Can you hide the "X" button in the upper right corner of the window?
• [FAQ000118]Is it possible to set up what Excel calls a filter on a CELF sheet?
• [FAQ000119]Can I print out and view the entire Action Set that I have created?
• [FAQ000120]How long is the session timeout for CELF?
• [FAQ000121]Is there any way to get the day of the week for a given date?
• [FAQ000122]Where can I check the version of CELF?
• [FAQ000124]Is it possible to display the date in yymmdd format?
• [FAQ000125]Is it possible to set the filter refinement automatically in an action?
• [FAQ000126] In [Test Run] at the bottom left of the "Action set setting" screen, another sheet does not appear
• [FAQ000127]How do you restrict access to CELF?
• [FAQ000128]When I tried to install CELF, I was asked for an administrator’s user name and password
• [FAQ000129]Even if you set the same values for "Row height" and "Column width" as in Excel, the actual appearance is different
• [FAQ000132]An error appears during the installation of CELF
• [FAQ000133]Is it possible to change the tables set in an action in bulk?
• [FAQ000134]The error "App import failed." appears
• [FAQ000135]Importing the app fails with an error message "Unsupported or incompatible operation found."
• [FAQ000136]I cannot resize the window when a child screen is displayed
• [FAQ000137]What does the "Aggregation key" in the "Aggregate table data and output" action specify?
• [FAQ000138]What is the difference between "Refine conditions before aggregation" and "Refine conditions of aggregation result" in the "Aggregate and output table data" action?
• [FAQ000139]How do I convert a cell’s value to a zero-filled value?
• [FAQ000140]How to change the selection of a list (LIST function) in an action?
• [FAQ000141]How do I compare two tables and search for data that does not match?
• [FAQ000142]When saving an action set using an SQL action, the message "SQL is incorrect." appears
• [FAQ000143]String concatenation on a zero-filled number causes the leading zero to disappear
• [FAQ000144]I’m making a graph in CELF, but I can’t set the upper limit of the scale to 100%
• [FAQ000145]I can’t launch the CELF app from the app link URL
• [FAQ000146]How do I display a QR code on a CELF sheet?
• [FAQ000147]Where can I download the CELF installer?
• [FAQ000148]Is it possible to find out who has rewritten the data?
• [FAQ000149]Can I store PDF files to CELF?
• [FAQ000150]When migrating from the trial version of CELF to the licensed version of CELF, is it necessary to reinstall CELF?
• [FAQ000151]When printing, if text with the alignment "Align right" is surrounded by a thick ruled line, the ruled line and the text will overlap.
• [FAQ000152]Is there a way to clear the contents of a cell using an action?
• [FAQ000153]When I export a sheet of CELF with frame fixing set to Excel format, the frame fixing is canceled
• [FAQ000154]The filtered rows are copied as well
• [FAQ000155]Can I run an action set from one app in another app?
• [FAQ000156]Is it possible to set the window size when the application (sheet) starts?
• FAQ000157]Is there a limit to the maximum number of records in the CELF database
• [FAQ000158]Is there a way to dynamically specify the selection range for the SUM function?
• [FAQ000159]Can I use previously created action sets as generic components?
• [FAQ000160]I want to save a CSV file with a specific file name and destination
• [FAQ000161] I want to specify the file name and destination when saving table data as a CSV file
• [FAQ000162]Is it possible to import and output files over the network?
• [FAQ000163]I can’t specify an entire column when using CELF functions to specify a range.
• [FAQ000164]Is there any way to export a CELF sheet as a PDF file?
• [FAQ000165]Is there a way to import only some of the items from a CSV file?
• [FAQ000166]How do I output only the items I need from a table?
• [FAQ000167]Can I "Sort" multiple columns in a prioritized order, like in Excel?
• [FAQ000168]I want to implement mandatory checks in the checkboxes on CELF sheets
• [FAQ000169]Is it possible to change the text displayed on the button to a new line?
• [FAQ000170]How do I set the values of multiple cells on different sheets?
• [FAQ000171]I want to check the checkbox according to the value retrieved from the table
• [FAQ000172]I want to output a CSV file in which all item values are enclosed in double quotation marks
• [FAQ000173]Is it possible to display the sheet name in the title bar?
• [FAQ000174]Can I restore my previous data?
• [FAQ000175]How can I check the SQL statement when executing a SQL action?
• [FAQ000176]What are the image file formats that can be inserted into CELF sheets?
• [FAQ000177]Is it possible to set any number system for the ID registered when uploading files?
• [FAQ000178]I want to register the entered values directly into the database
• [FAQ000179]Does CELF’s VLOOKUP function support the wildcard "*"?
• [FAQ000180]The message "Serialization error: Invalid magic number 0x0 found in stream header." appears inCurl RTE Console.
• [FAQ000181]I wanted to start the cloud version of CELF, but when I double-clicked the shortcut, IT-STUDY started
• [FAQ000182]When I output data using the "Aggregate and output data from table []" action, blank rows appear. What should I do?
• [FAQ000183]In the "Copy and paste cell [] to []" action, is it possible to specify a range and copy it to another sheet?
• [FAQ000184]The error "Unable to update priviledged files" appears while installing
• [FAQ000185]How do I write SQL for fuzzy search when using SQL actions?
• [FAQ000186]How do I set the initial position of the cursor to the top when displaying a sheet?
• [FAQ000188]The message "This sheet might have already been published." appears
• [FAQ000189]When I run the created CELF sheet on another device, the text looks squashed
• [FAQ000190]The error "It is not possible to register because the currently used IP address is not specified. Please check the set IP address." appears
• [FAQ000191]Is it possible to run applications created with the latest version on past versions of CELF?
• [FAQ000192]There is a difference between the characters that can be displayed in Excel and CELF
• [FAQ000193]Unexpected locale is selected in date and time cells of the exported Excel file
• [FAQ000194]I am trying to connect to MySQL using ODBC and register data using an action, but an error occurs when executing the action