B4A Tutorial Data Type and Range - metrick    Mar 2, 2011   (1 reaction) Where do I find data range for B4A;
float
int
double
long
single
decimal
currency
etc...
List from VB.
Thanks.... B4J Tutorial [XLUtils] Templates and Charts - Erel    May 3, 2021   (10 reactions) are needed. It works by creating a dynamic named data range and setting it as the chart's data source. Later we will overwrite the dynamic data range with a standard named range with the known size. The steps to create a dynamic named data range are demonstrated in the video. It is done....CreateWriterFromTemplate instead of CreateWriterBlank. Charts If the source data size is known then..., <number of rows>, <number of columns>) The <top left cell> points to the first data... B4J Tutorial Excel Charts and Templates with jPOI library - Erel    Aug 27, 2015   (8 reactions)   tags: B4J Excel Charts Template with a chart, modify the data and write it. This is a simple and good solution if the data range is always the same. However if the data range can change then you need to use dynamic named ranges.... The program will: Read the template file. Fill the data. Update the two ranges based on the number of items. Save the workbook as a new file. Updating the ranges is done with this code: Private... named ranges: https://support.microsoft.com/en-us/kb/183446) The actual ranges are not really... B4A Question B4XTable Create a Custom Format for a Numeric Range Breaks Down after First Page - Mahares    Dec 14, 2020   (1 reaction) .Formatter = formatter Dim range As B4XFormatData= c.Formatter.NewFormatData range.TextColor = Colors.Red '100 thru 115 are red, rest black c.Formatter.AddFormatData(range,100, 115...On the first page, the numbers equal or lower than 115 are in red, the rest higher than 115 on the same page are in black as expected. When I move to the 2nd page, the color remains red despite the values are larger than 115 Sub B4XTable1_DataUpdated CreateCustomFormat(x) 'works for 1st... B4A Question B4XTable unable to show large numbers (>2147483647) of Long type - toby    May 8, 2021 If the column type is NUMBERS, It can only handle Int data range (max 2147483647). To prove that, try to show a Long value of 2147483648 (2147483647+1) and what you would see is "Overflow" instead. My workaround: change column type from NUMBERS to TEXT. Did I miss anything?... B4A Library [B4X] FTP Server implemented with Socket and AsyncStreams - Erel    Jul 18, 2022   (40 reactions)   tags: B4A B4J, FTP the control port and the range of available data ports. When running on a non-mobile device... on the control port (main port). It also manages the connected clients and assigns a data port for... for each task that requires communication over the data socket (upload, download and list files). FTPDataConnection - An instance is created for each data task. It sends or receives the data and then... the channel after the data was sent (SendAllAndClose). Clients expect the data socket to be closed after... B4A Library [B4X] BytesBuilder - simplifies working with arrays of bytes - Erel    Oct 13, 2019   (42 reactions)   tags: array, B4X BytesBuilder Class, B4X, string byte . Modifying the stored data is done with: Append - Adds data at the end. Insert - Inserts data at the given index. Set - Replaces data starting from the given index Remove - Removes the data in the given range. Clear - Clears the data. Note that the internal buffer grows automatically as needed. Reading the data is done with: SubArray / SubArray2 - Similar to String.SubString ToArray - Similar to StringBuilder.ToString. Returns a complete copy of the data. IndexOf / IndexOf2 - Similar to... B4A Library [B4X] [XUI] AS DatePicker - fast navigate to a Month - Year - Decade - Century | RangeDatePicker - Alexander Stolte    Mar 1, 2024   (22 reactions) , you select a month In the decade you see a range of 10 years In century you can see 100 years 128054128055128057128056 PbSeTWFnQLw 128661 SelectMode = Range 138202 Make sure you are using ASViewPager V2.01... As ASDatePicker_CustomDrawDay) SelectedDateChanged (Date As Long) SelectedDateRangeChanged (StartDate As Long... As Long Only in SelectMode "Range" getSelectedStartDate As Long getSelectMode As String getSelectMode_Day As String getSelectMode_Month As String getSelectMode_Range As String... B4A Tutorial š” [B4X] [XUI] [B4XPages] B4A PreoptimizedCLV lazy loading from SQLite and CSV - Newer developers - Peter Simpson    Feb 23, 2021   (28 reactions) how to manipulate files and insert the data into multiple PreoptimizedCLV. The CSV file has 249 rows (2 columns) and the SQLite database table has 280,932 rows of data, the population data ranges from... PreoptimizedCLV to retrieve country population data and flag images. Using a PreoptimizedCLV to display rows of data, card, images etc is extremely efficient and fast, even on older or slower devices... do so. The population data comes directly from the UN, link below. https://www.un.org/development... B4J Question XLUtil - working with Ranges on multiple sheets - mfstuart (first post)    Oct 6, 2021 ) get a named range from the sheet
4) read that range of data (data is in Columnar and Row format)
5) load a B4XTable with the range data
6) Press a button to INSERT table data into a SQL table
Done....GetRange("MyRange")
TableData.SetData(range.GetData)
Set B4XTable.ColumnHeadings(???) 'from 1st row in range data
B4XTable.SetData(TableData)
I've tried a few things and it isn... Page: 1   2   3   4   5   6   7   |