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