Frequently asked questions

This page introduces frequently asked questions about CELF.

• General questions
  • [FAQ000025]Is there a minimum usage period?
  • [FAQ000027]How can I ask questions to CELF Support?
  • [FAQ000041]What do I need to install on my PC to use CELF?
  • [FAQ000042]Does the system support user information linkage with Active Directory and single sign-on?
  • [FAQ000044]Is Client web-based?
  • [FAQ000056]Will I be unable to register data if the disk space I am using exceeds the limit?
  • [FAQ000068]Is it possible to set CELF to lock when multiple login attempts fail?
  • [FAQ000094]Does CELF work in a virtual environment?
  • [FAQ000123]Where can I check the maintenance information of the cloud version of CELF?
  • [FAQ000130]Can multiple users log in with a single user ID at the same time?
  • [FAQ000131]If I log in from a different computer, will I be treated as two users?
• How to use, technical questions
  • [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